Hello,
I am currently creating a Windows to UNIX Report using the Reporting Services of Microsoft SQL Server.
declare
cnt_inqnum integer ;
logged varchar(20);
begin
select COUNT(INQ_NMBR) into cnt_inqnum FROM Orders WHERE INQ_NMBR = '10' ;
if cnt_inqnum > 0
then
logged := 'Yes';
else
logged := 'No';
end if;
end;
Upon running the query above, this error message pops up:
| ORA-00900: | invalid SQL statement |
I tried running this same query in Benthic Software and it is working properly. I also researched on what may cause this error. This is what I found:
| Cause: | The statement is not recognized as a valid SQL statement. This error can occur if the Procedural Option is not installed and a SQL statement is issued that requires this option (for example, a CREATE PROCEDURE statement). You can determine if the Procedural Option is installed by starting SQL*Plus. If the PL/SQL banner is not displayed, then the option is not installed. |
| Action: |
Correct the syntax or install the Procedural Option. I checked if the Procedural option is installed, and yes it is. I am thinking that the problem may not be an oracle type but a Reporting Service bug.. I hope you could help me fix this error... thanks in advance :) |
Microsoft SQL Server - Reporting Services - Using Oracle 9i Database