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

No comments posted yet

Your Answer:

Login to answer
112 Like 6 Dislike
Previous forums Next forums
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

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash