Print Thread
test window bug
#59967 04/26/19 10:10 AM
Joined: Aug 2003
Posts: 54
EE
M
marek Offline OP
Member
OP Offline
Member
M
Joined: Aug 2003
Posts: 54
EE
Hi,
I think there's a bug here in parsing:
ORA-01008: not all variables bound
[quote]
BEGIN
-- Test statements here
EXECUTE IMMEDIATE q'<begin
:1 := regexp_replace(some_func(),'([^/]+/*){1}$');
end;>'
USING OUT :c;
END;
[/quote]
PL/SQL Developer
Version 13.0.4.1906 (64 bit)

Last edited by marek; 04/26/19 10:11 AM.

Regards,
Marek
Re: test window bug
marek #59968 04/27/19 09:43 AM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
This seems to be a bug when scanning the PL/SQL Block for bind variables, caused by the q'<string>' expression. We'll fix it.

There are 2 workarounds:

1. Don't use q'<string>' expressions:

Code
BEGIN
  -- Test statements here
  EXECUTE IMMEDIATE 'begin
                       :1 := regexp_replace(some_func(),''([^/]+/*){1}$'');
                     end;'
  USING OUT :c;
END;
2. Disable the "Automatically scan bind variables before Execute" option on the Configure > Preferences > Window Types > Test Window page. In this case you need to explicitly declare the :C bind variable in the Test Window.

Last edited by Marco Kalter; 04/27/19 09:43 AM.

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.047s Queries: 14 (0.014s) Memory: 2.5005 MB (Peak: 3.0427 MB) Data Comp: Off Server Time: 2024-05-17 11:15:01 UTC
Valid HTML 5 and Valid CSS