Home » SQL & PL/SQL » SQL & PL/SQL » string O numbers in IN??
string O numbers in IN?? [message #20203] Mon, 06 May 2002 12:26 Go to next message
DRE
Messages: 9
Registered: March 2002
Junior Member
Hi,
I have a problem in that I want to pass a string var that contains a list of numbers into the IN () operator of a cursor. Like IN(stringvar) However, oracle seems to be giving errors because it wants to put some quotes around the string dynamically. Is there a work around? It would seem fairly standard.
Tks in advance. DRE

Report message to a moderator

Re: string O numbers in IN?? [message #20204 is a reply to message #20203] Mon, 06 May 2002 12:59 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:110612348061

Report message to a moderator

Previous Topic: Re: Calculate days between dates.
Next Topic: SQLPLUS commands
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 14:34:00 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.