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

SQL Error = ORA-01747:

Hi all

   I am trying to run the GLS7010.sqr and getting this error

\\serv08\prod\fin\ps750\sqr\gls7010.sqr: GLS7010 - SQL Statement =
PRCSAPI.SQC,Get-Job-Instance,Select,PSPrcsRqst
SQL Status = -1747, SQL Error  = ORA-01747: invalid user.table.column,
table.column, or column specification

  I have looked at the PRCSAPI.SQC where the error is coming from and when I
run the sql all is fine. Has anyone seeen this error or could help me out

Thanks
Anne