Home » SQL & PL/SQL » SQL & PL/SQL » about multiple values passing in single parameter (oracle9.2)
about multiple values passing in single parameter [message #287891] Fri, 14 December 2007 00:02 Go to next message
parasuramchekuri
Messages: 32
Registered: March 2007
Location: vishakapatnam
Member
hi all
i have problem

as per my requirement i want to pass single or more values to the parameter, for this what datatype can i use how to get values from that parameter

thanks in advance
Parasuram...
Re: about multiple values passing in single parameter [message #287897 is a reply to message #287891] Fri, 14 December 2007 00:33 Go to previous messageGo to next message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Post an example of what you want, it is really not clear.
I think collection is what you need.

Regards
Michel
Re: about multiple values passing in single parameter [message #287906 is a reply to message #287897] Fri, 14 December 2007 00:46 Go to previous messageGo to next message
parasuramchekuri
Messages: 32
Registered: March 2007
Location: vishakapatnam
Member
hi

my actual requirement is in Stored procedure i have one parameter like itemcode,
for that item code i can pass single itemcode, but my requirement is
pass one or more values with comma separted through java code
is it possible to pass like that or not
thanks
ram
Re: about multiple values passing in single parameter [message #287908 is a reply to message #287906] Fri, 14 December 2007 00:52 Go to previous message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes.
Either use a string to pass the list and "unlist" it in the code, either use a collection type (array) as parameter.

Regards
Michel
Previous Topic: Auto ID + letter
Next Topic: shifting records
Goto Forum:
  


Current Time: Tue Dec 06 02:41:32 CST 2016

Total time taken to generate the page: 0.10203 seconds