Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

string parameter in Crystal 9 command against Oracle getting ORA-24374

Status
Not open for further replies.

Mountaine

Instructor
Apr 9, 2003
10
This command works fine:
SELECT INSTR('2000,2700',SUBSTR(fieldname,1,4)) TESTFIELD FROM tablename

but when I create a parameter MyParam within the command and give it a default value of 2000,2700 I get an ORA-24374 with this:

SELECT INSTR({?MyParam},SUBSTR(fieldname,1,4)) TESTFIELD
FROM tablename

And I still get the ORA-24374 with this:

SELECT INSTR('{?MyParam}',SUBSTR(fieldname,1,4)) TESTFIELD
FROM tablename
 
In case anyone cares, the problem was solved when I switched from Oracle's driver to the CR driver for Oracle.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top