Skip to content
Advertisement

Create a stored procedure in a package oracle

I have created the following package in Oracle:

Here is my procedure that I’m trying to create:

When I try to create the procedure, I get the following messages:

Error(8,3): PL/SQL: SQL Statement ignored Error(8,8): PLS-00456: item ‘P_ITEM’ is not a cursor

I’m new to this with packages and procedures in Oracle.

Advertisement

Answer

You cannot open a cursor on a TYPE RECORD. It has to be of CURSOR type. So, Just replace this whole statement –

WITH

User contributions licensed under: CC BY-SA
2 People found this is helpful
Advertisement