[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