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

Login page problems
I developed a website a few months ago and I am now having an issue with logging into it. The place

Schedule editor
Hi,

I have a question related to Schedule editor.
If we schedule a BLS for every 30

Error Messaging not working
I changed the way my form tells the user of an error. But I can't seem to get it to work properly.

Checking if multidimensional array is empty?
I have a for with multiple test input fields. Specifically the user submits multiple names and ages

need help with mail()
hi i want to send an email with attaching pdf file using php. i have the following script but the pr

asking for direction
I have 2 tables in my data, which are "post" and "event"
I won't make a summa

Checking if variable is 0 as opposed to NULL/Empty...
I'm trying to write some code that will retrieve a user's access level from my database and if it do

how to make database item unique
Hey guys,

is it possible to do this:

I have the database item $title being pulled for

Help: problem with Headers to download PDF file
Hi,

I'm trying to implement a script where when a user clicks a link he gets a PDF file to op

how to query data from website using VC?
I want to query some datum from a website,so I need a program to read data from a .csv file, and ass