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