Call stroed procedure using sqlda

Bobby123 · #1 (**permalink**) 12-22-11, 03:51

I am porting a code from DB2 to ORACLE

In DB2 , a stored procedure is called using sqlda. calling syntax is given below

EXEC SQL CALL procedure_name USING DESCRIPTOR :sqlda

I want to do same thing in ORALCE , but not able to find out correct method

Thanks in Advance

Littlefoot · #2 (**permalink**) 12-22-11, 05:04

Where would you want to call the procedure from? Generally speaking, you should enclose it within BEGIN-END, such as

Code:

begin
  procedure_name;
end;

Bobby123 · #3 (**permalink**) 12-22-11, 05:25

I want to call the the procedure from Embedded SQL file. I want to use the structure sqlda which is declared in sqlda.h

I have already created sqlda structure for procedure ,but don't know how to use that in calling stored procedure.

Like--
begin
procedure_name(param 1,param 2...);
end;

in place of (param 1,param 2...) ,I want to use sqlda structure.

anacedent · #4 (**permalink**) 12-22-11, 10:27

Getting Started With Pro*C

Internet Services

Web Development

Digital Marketing

Consumer Tech