Re: Urgent -Calling oracle procedure within Delphi

Ach C via DBMonster.com wrote:
> Is there any Oracle guy who knows Delphi? I need help in calling oracle
> stored procedures by delphi application.My procedure is simple:
> [code]CREATE OR REPLACE PROCEDURE test_proc2(p_result OUT sys_refcursor) AS
> BEGIN
> OPEN p_result FOR
> SELECT * FROM emp;
> END;[/code]
> I don't know how should I call this procedure within Delphi and return the
> cursor.I want to put the returned cursor into a grid.
> -your help will be so appreciated.
>
>

I can only second Brijesh's answer:

With the information given, it's hard to help you. And since people do this on their own time, they won't write the at least 4 sample applications to cover the possibilities.

Besides: I've long ago given up using data sensitive controls and never looked back. If you ever decide that e.g. ODBC isn't the finest piece of code (to use the term in its loosest sense) that ever came from Microsoft, you might find that the new access components of your choice don't have the same cursor representation as ODBC provided. So you might find yourself reworking your application not only the data access layer but also the data representation layer and believe me, that's going to hold some nasty surprises!

My 2 cents, anyway.

Holger Received on Mon Aug 22 2005 - 06:49:33 CDT