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!

Getting :WRONG NUMBER OR TYPES OF ARGUMENTS IN CALL TO 'OGC_X' ERROR

481225Sep 26 2006 — edited Oct 3 2006

Hi all,

While running the below query i am getting the following error.Could anyone help me out?

Error:ORA-06553:PLS-306: WRONG NUMBER OR TYPES OF ARGUMENTS IN CALL TO 'OGC_X'

SELECT
y.record_type
, y.vendor_site_code as object_name
, decode(y.insert_update_flag, 'I', 'INSERTED', 'U', 'UPDATED', NULL) as status_type
, y.status
, x.error_text
, x.row_id
FROM
XXEFSS_POVEND_SITES_INTERIM y
, XXEFSS_POVEND_ERRORS_INTERIM x
WHERE x.row_id = y.rowid

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 31 2006

Added on Sep 26 2006

9 comments

4,131 views