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

Did you know?Explore Trending and Topic pages for more stories like this.
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

$_POST variable un-useable
I'm trying to use a $_POST variable in a mysql update statement but i can't use it for some unknown

re calling a function without including file
Hi,
i am new to programming in php, i was just checking the wordpress code and found out in the w

Read from a text file after a specific word
Hi all.

I have a text file that looks like the one below.
I know how to open the text fi

Warning message
I've put a website that I was doing live and I'm getting this warning message when I try to add a ne

What am I missing here? Help!
Hello all!. I can't seem to get this working right. Well - it renders right, but something is goin

set xml path in flash when xml created in memorystream and webrequest
i am creating an xml file using memory stream and i want to load this xml file into the flash on cli

how do i make a string??
hey guys,
can someone please tell me how to put data from the glob function into a string

defining website tags
Hi,

What would be the best way to define tags for my site, such as website title, url etc.

checkbox update
I am having a brain fart right now and i cant remember how to do this. if anyone could help that wou

This must be easy , pulling the last record of the day, every day, from a txt
I have a txt file logging weather data every minutes (so 1 record per minute). I want to extract 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