Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

PL/SQL Packages in C

Hi All,
I would like to know if it is possible to call a PL/SQL package directly from my C code/program. I know that you use embedded SQL and the EXEC SQL command to define and execute SQL but is there a way I can pass values directly to the package? Please help :)

Thanks :)

Comments

  • zeronezerone Member Posts: 24
    [b][red]This message was edited by Moderator at 2002-11-27 9:11:16[/red][/b][hr]
    : Hi All,
    : I would like to know if it is possible to call a PL/SQL package directly from my C code/program. I know that you use embedded SQL and the EXEC SQL command to define and execute SQL but is there a way I can pass values directly to the package? Please help :)
    :
    : Thanks :)
    :
    :
    Here you can find more information.
    http://gwynne.cs.ualberta.ca/~oracle/817doc/appdev.817/a76942/toc.htm

    This should be interseting for you:
    http://gwynne.cs.ualberta.ca/~oracle/817doc/appdev.817/a76942/pc_07pls.htm#2778

    I never worked with embedded PL/SQL in C, but I have worked with embedded SQL. If you want I can give you a example of this.
    I think it is more or less the same.

    Cheers,
    [italic]"We must work in team, or we die"[/italic]
    - The single dead guy WWII.



  • HearMeNowHearMeNow Member Posts: 2
    : [b][red]This message was edited by Moderator at 2002-11-27 9:11:16[/red][/b][hr]
    : : Hi All,
    : : I would like to know if it is possible to call a PL/SQL package directly from my C code/program. I know that you use embedded SQL and the EXEC SQL command to define and execute SQL but is there a way I can pass values directly to the package? Please help :)
    : :
    : : Thanks :)
    : :
    : :
    : Here you can find more information.
    : http://gwynne.cs.ualberta.ca/~oracle/817doc/appdev.817/a76942/toc.htm
    :
    : This should be interseting for you:
    : http://gwynne.cs.ualberta.ca/~oracle/817doc/appdev.817/a76942/pc_07pls.htm#2778
    :
    : I never worked with embedded PL/SQL in C, but I have worked with embedded SQL. If you want I can give you a example of this.
    : I think it is more or less the same.
    :
    : Cheers,
    : [italic]"We must work in team, or we die"[/italic]
    : - The single dead guy WWII.
    :
    :
    :
    Hi There,
    Thanks for your reply :) Yeah, I meant embedded SQL. I have done research OCI and Pro*C, which is probably what I am going to use. I don't have an example to show you because I haven't coded anything yet. I'm finding/researching ways in which I can trigger packages from within C. Thanks for your help :)

Sign In or Register to comment.