Home » SQL & PL/SQL » SQL & PL/SQL » Is It Possible To define a size of the Procedure Parametere? (Oracle 10G)
Is It Possible To define a size of the Procedure Parametere? [message #339277] Thu, 07 August 2008 03:45 Go to next message
rangan.s
Messages: 75
Registered: February 2008
Location: chennai
Member
In Oracle Is It Possible To define a size of the Procedure Parametere?

If i have the procedure like

Test_sp(no int,name varchar2)

Is it possible to define a size

Test_sp(no int(5),name varchar2(255))


Thanks
Rangan S
Re: Is It Possible To define a size of the Procedure Parametere? [message #339284 is a reply to message #339277] Thu, 07 August 2008 03:52 Go to previous messageGo to next message
Olivia
Messages: 519
Registered: June 2008
Senior Member
Try! what it says?
Re: Is It Possible To define a size of the Procedure Parametere? [message #339291 is a reply to message #339277] Thu, 07 August 2008 04:06 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have to predefine a type and use this type if you want to constraint the size.

Regards
Michel
Previous Topic: Can anybody solved this query
Next Topic: getting variable's size runtime ? is it possible in pl/sql
Goto Forum:
  


Current Time: Sun Dec 04 06:20:09 CST 2016

Total time taken to generate the page: 0.03812 seconds