SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

MISSING LEFT PARENTHESIS

831655Mar 1 2011 — edited Mar 1 2011

HI,,,

I DONT KNOW IF I AM COMMITING ANY MISTAKE HERE.
NVL(Patient.Registration_No, '') RegistrationNo,
NVL(fn_PatientFullName(Visit.PatientID), '') PatientName,
Billing_Mst.BillNo NumberS,
Billing_Mst.BillDate RDate,
Billing_Mst.GrossAmount,
Billing_Mst.DiscountAmount,
CAST(BillingMst.NetAmount AS VARCHAR2) Amount,_*+
Billing_Mst.DueAmount,
Visit.VisitNo,
Visit.VisitDate,

THE ERROR ITS IGIVING IS

Error(21,52): PL/SQL: ORA-00906: missing left parenthesis

This post has been answered by 21205 on Mar 1 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 29 2011

Added on Mar 1 2011

4 comments

4,540 views