topic-25670

Board index FiveWin for Harbour/xHarbour execute Procedure in Oracle...?

Mulyadi

Posts: 85

Joined: Mon Apr 18, 2011 02:32 AM

execute Procedure in Oracle...?
Posted: Tue Feb 19, 2013 08:29 AM

To all

I want to execute a procedure or function in oracle.
any one can posting sample here...?

TQ.

Mulyadi.

Mulyadi

Posts: 85

Joined: Mon Apr 18, 2011 02:32 AM

Re: execute Procedure in Oracle...?
Posted: Wed Feb 20, 2013 12:45 AM

Halooooooo........

I create a Procedure or Function or Sequence in Oracle,
but i dont know how to execute it with FWH.....

Muyadi.

nageswaragunupudi

Posts: 10733

Joined: Sun Nov 19, 2006 05:22 AM

Re: execute Procedure in Oracle...?
Posted: Wed Feb 20, 2013 10:31 AM

I assume you are using ADO
Simple stored procedure without paramters:

Code (fw): Select all Collapse

   oCmd     := TOleAuto():New( "ADODB.Command" )
   WITH OBJECT oCmd
      :ActiveConnection    := oCn  // Connection object already created
      :CommandText         := <StoredProcName>
      :CommandType         := adCmdStoredProc   // Value is 4
   END
   // Assuming there are no paramters for the stored procedure
   
   // Execution
   oCmd:Execute()

I recommend reading ADO in w2schools.com

Regards

G. N. Rao.

Hyderabad, India

Mulyadi

Posts: 85

Joined: Mon Apr 18, 2011 02:32 AM

Re: execute Procedure in Oracle...?
Posted: Thu Feb 21, 2013 03:32 AM

Thanks Mr Nages.

I try it and i posting the result later...

FiveTech Support Forums

Continue the discussion