Print Thread
Error in command window with bind vars and '--' string
#30993 10/31/08 02:52 PM
Joined: Nov 2003
Posts: 35
F
Member
OP Offline
Member
F
Joined: Nov 2003
Posts: 35
Hello,
the following commands raise an error "ORA-01008: not all variables bound":

create table t (col1 number(1), col2 varchar2(3), col3 number(1));
define v=1
insert into t values(&v, '--', &v);
commit;
drop table t;

The PL/SQL Developer command processor seems to have a problem with the string '--'.
This problem does not occur in SQL*Plus.

I run the current Version 7.1.5.1398

Regards
Frank

Re: Error in command window with bind vars and '--' string
#30994 10/31/08 04:08 PM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
We'll fix it. A possible workaround is:

insert into t values(&v, '-'||'-', &v);


Marco Kalter
Allround Automations

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.064s Queries: 13 (0.046s) Memory: 2.4978 MB (Peak: 3.0407 MB) Data Comp: Off Server Time: 2024-05-18 06:33:35 UTC
Valid HTML 5 and Valid CSS