[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

SQR-Oracle PL/SQL error



I'm using Brio report builder 6.13(Build 90)

Here is the code:

Begin-Procedure CallProcFind1000
begin-sql
 declare
 v_word varchar2(3);;
 begin
 v_word := 'hel';;
 end;;
end-sql
end-procedure

Here is the error:
  
 [INTERSOLV][ODBC Oracle driver][Oracle]ORA-06550: line 1, column 21:
PLS-00103: Encountered the symbol ";" when expecting one of the following:

   begin declare end exception exit for goto if loop mod null
   pragma raise return select update while <an identifier>
   <a double-quoted delimite

Error on line 58:
   (SQR 3735) Could not execute SQL.

SQR: Program Aborting.

Does anyone have an idea about what might be wrong?  I hope it is obvious that 
I simplified the code to try to solve the problem.  It didn't seem to help.  I 
found that anytime I call PL/SQL from begin-sql I seem to get this error.  
Should I be using a different driver?  I tried this code against Oracle 7.34 
and Oracle 8i with no luck.

Thanks,
Tim