Calling a Procedure with IN & OUT Parameters

Posted on 16th Feb 2014 07:03 pm by admin

Hello,

I usually call my procedures using the following way

declare variable error_msg varchar2(50)
exec simple_msg('ABC,'ABC','ABC',:error_msg);

CREATE OR REPLACE PROCEDURE SIMPLE_MSG (
ID IN VARCHAR2,
URL IN VARCHAR2,
LIST IN VARCHAR2,
ERROR_MSG OUT VARCHAR2

*************************************************************
Now my question is i am trying to call a proc which has IN OUT parameters. Can somebody guide me on how to call the proc. Thanks

CREATE OR REPLACE PROCEDURE SIMPLE_MSG (
ID IN VARCHAR2,
URL IN VARCHAR2,
LIST IN VARCHAR2,
NAME IN OUT VARCHAR,
ERROR_MSG OUT VARCHAR2

Your Answer:

Login to answer

Other forums

Renaming array keys
The issue: renaming array keys inside a foreach loop.

I'm trying to build a pie chart image w

search function
HI guys,

if anyone could point us in the right direction of how to do this, or provide some t

Help with Password Encoding/Decoding?
Trying to design a "change password" tool. On my signup code I'm using base64_encode, now

Trouble with a select list
Hello All!
I was wondering if any of you guys could help me with a small problem I'm having!

Simple Variable Question
Hi everyone.... again,

I am really getting into php still. Learning more every day. I love it

Search function
I am looking for some guidance from the experts.

I am trying to create a search function. It

Grouping and sorting results
Please help with this query.

I have 2 tables in a database, countires and cities. states look

do while...woes
I'm sure this is childsplay but it is stumping me, everytime i try what I think would make this work

Script not running properly
Hello Everyone
This is a basic script for posting to a database. I'm not sure why it doesn't work

sapgui f4 help last search
I know this has to be simople. One user (maybe more) does not have the "last search saved" from the