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

    Unanswered: pass structure to procedure

    I am porting a DB2 ESQL to ORACLE ESQL. In DB2 we can pass a structure in procedure by statement

    EXEC SQL CALL procedure_name USING DESCRIPTOR: structure_name;

    i want to modify the above line for oracle.

    Thanks in advance

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Since I don't know DB2 or what a DB2 structure looks like
    I don't know what might be equivalent in Oracle.
    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.

  3. #3
    Join Date
    Dec 2011
    Posts
    10
    In ESQL/ORACLE we can call procedure BY

    EXEC SQL CALL procedure_name(:tr_1,:tr_2,....);

    If you can tell me how can i call that procedure using a C structure test1 which is

    Struct testpr
    {
    int tr_1;
    int tr_2;
    .......
    };

    struct testpr test1;

    instead of (:tr_1,:tr_2,....), that can also be helpful.

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    I believe that TYPE datatype should meets your requirements.
    I suggest you run some simple proof of concept tests to learn what actually works for you.
    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
  •