Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

performance Tuning 10g reference poster
 
Oracle training in Linux 

commands
 
Oracle training 

Excel
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> error in the OUT parameter., OUT parameter not worked in unix
khawajah
post Feb 23 2012, 01:40 PM
Post #1


Newbie
*

Group: Members
Posts: 4
Joined: 22-February 12
Member No.: 46,812



hi,
when i execute pl/sql procedure with IN and OUT parameter in UNIX then:
the IN is working fine but the OUT give me error.

the error of the execution:
SQLException when calling JDBCConnection.callProcedure().
java.sql.SQLException: Parameter 7 not set; Wrong number of parameters.
Go to the top of the page
 
+Quote Post
HAL9000
post Feb 23 2012, 02:42 PM
Post #2


Advanced Member
***

Group: Members
Posts: 876
Joined: 25-September 07
Member No.: 12,336



Please note that this is an Oracle DBA forum, sadly we are not PL/SQL developers here!

"Wrong number of parameters. "

"Parameter 7 not set;"

You need to declare the parameter in your shell script to accept the out parameter, and specify this parm in your call to the procedure too.

There is a worrking example in the book "Oracle shell scripting:

http://www.rampant-books.com/book_0701_shell_scripting.htm


Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 23rd April 2014 - 01:17 PM