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...

Report message to a moderator

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: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

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

Report message to a moderator

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: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Dec 14 14:46:36 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.