Subject: SQL*Plus: Release 3.2.2.0.0

From: Dylan Cooper <dylan_at_pictor.ccit.arizona.edu>
Date: 1996/01/26
Message-ID: <4eau4a$kqu_at_news.ccit.arizona.edu>#1/1

Can anyone explain the following behavior? (I think it's a SQL*Plus bug, but maybe it's a feature.) I'm running:

	SQL*Plus: Release 3.2.2.0.0 - Production
	Oracle7 Server Release 7.2.2.3.0 - Production Release
	PL/SQL Release 2.2.2.3.0 - Production
on Solaris 2.3 and getting:
	ORA-01008: not all variables bound

when I should not. This is causing significant problems.

Here is an example. I run this SQL script:

	variable period_text varchar2(40)
	variable bill_contact varchar2(100)
	execute :bill_contact := 'AAAA';
	execute :period_text := 'BBBB';
	
	select
		decode ( 
			:bill_contact
			, 'a', 'A'
			, :bill_contact
		)
		, :period_text
	from 
		dual
	/

And I get:

        PL/SQL procedure successfully completed.    

        PL/SQL procedure successfully completed.    

	ERROR:
	ORA-01008: not all variables bound
 
 
 
	no rows selected

Received on Fri Jan 26 1996 - 00:00:00 CET