Home » SQL & PL/SQL » SQL & PL/SQL » parameters for pl/sql procedure
parameters for pl/sql procedure [message #37006] Wed, 09 January 2002 23:35 Go to next message
tinel
Messages: 42
Registered: November 2001
Member
Hi
Does anybody know if there is a maximum number for the parameters in a pl/sql procedure?

Thank's

Report message to a moderator

Re: parameters for pl/sql procedure [message #37007 is a reply to message #37006] Thu, 10 January 2002 00:07 Go to previous message
fionan
Messages: 5
Registered: January 2002
Junior Member
hi,
There can be any number of parameters, each followed by a mode and a type. The possible modes are IN (read-only), OUT (write-only), and INOUT (read and write). Note: Unlike the type specifier in a PL/SQL variable declaration, the type specifier in a parameter declaration must be unconstrained. For example, CHAR(10) and VARCHAR(20) are illegal; CHAR or VARCHAR should be used instead. The actual length of a parameter depends on the corresponding argument that is passed in when the procedure is invoked.

Report message to a moderator

Previous Topic: how to find terminal and session id from weblogic.
Next Topic: define please
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat May 17 05:58:23 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.