Urgent -Calling oracle procedure within Delphi

Dev Shed Forums Sponsor:

August 21st, 2005, 06:21 AM

Ach

Contributing User

Join Date: Oct 2004

Posts: 46

Time spent in forums: 6 h 36 m 29 sec
Reputation Power: 4

Urgent -Calling oracle procedure within Delphi

Is there any Oracle guy who knows Delphi? I need help in calling oracle stored procedures by delphi application.My procedure is simple:

sql Code:

Original - sql Code
CREATE OR REPLACE PROCEDURE test_proc2(p_result OUT sys_refcursor) AS BEGIN OPEN p_result FOR SELECT * FROM emp; END;

CREATE OR REPLACE PROCEDURE test_proc2(p_result OUT sys_refcursor) AS
BEGIN
  OPEN p_result FOR
    SELECT * FROM emp;
END;

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.

Last edited by pabloj : August 21st, 2005 at 02:32 PM. Reason: Better use the new syntax highlighting features ;-)

August 21st, 2005, 02:27 PM

pabloj

Modding: Oracle MsSQL Firebird

Dev Shed God 6th Plane (7500 - 7999 posts)

Join Date: Jun 2001

Location: Outside US

Posts: 7,826

Time spent in forums: 2 Months 3 Weeks 1 Day 10 h 29 m 39 sec
Reputation Power: 278

I know nothing about Delphi, but this might help

__________________
My blog about OpenSource Databases
PDF tutorials about OSS databases, DBMonster ...
Please contribute to Open Source Development, fill bug reports!!!
Developer Shed eSupport
Commented my.ini/my.cnf (PLEASE ADD YOUR OWN CONFIG TRICK)
An introduction to database normalization
Natural or Surrogate key
Custom ordering for your results
Correlated and uncorrelated subqueries
Don't turn your outer joins into inner joins

Viewing: Dev Shed Forums > Databases > Oracle Development > Urgent -Calling oracle procedure within Delphi

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump