Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2011
    Posts
    10

    Unanswered: Call stroed procedure using sqlda

    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

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    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;

  3. #3
    Join Date
    Dec 2011
    Posts
    10
    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.

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •