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

Is there a more efficient way to code this than what I have?
I have three associative arrays.

$combinedSettings
$userSettings
$defaultSettings

filesize() returns 0
I have a socket program that runs in an infinite loop, listening for connections, in this socket I h

Windows 7
Windows 7 default user account control worries experts. Corporate IT departments should be pleased w

please help me in this update statment
hi every one

if I have table and this data in it

id name
10

Just wondering what you think about my site
I am new to phpfreaks i just seen this form and thought it would be cool to see what other thought a

Get to know your fellow coder
I think it's time we got personal around here. There's a lot of code swapping and a few members kno

PHP IMAGE UPLOAD SCRIPT
Hi for the last week i have been looking for scripts that will upload a photo to a certain folder wh

generate seo frienly url from a text like wordpress
Convert: "åäö" to "aao", "space" to "-", "!?&q

Session variable help
I'm having a very troubling issue. Maybe I'm just looking over something but I have looked at the co

PHP MySQL and DATE
Hi everyone

I have a databse and in one of the columns I have date values such as 2009-March-

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