How to insert data from one to another PL/SQL using procedure

Profile: govadagk
Tags:
PL/SQL
I am trying to insert the data to PO_HEADERS table from po_header_temp. There are 3 columns (PO_ID_REQ int,SALES_ORDER_NUM varchar2(400),QUOTE# varchar2(400)). I have tried the following procedure.
CREATE or REPLACE PROCEDURE PO_SAP_DATA
(
PO_ID_REQ int,
SALES_ORDER_NUM varchar2(400),
QUOTE# varchar2(400)
)
AS
BEGIN
INSERT INTO
PO_HEADERS(PO_ID_REQ,SALES_ORDER_NUM,QUOTE#)
SELECT
po_header_temp.PO_ID_REQ,po_header_temp.SALES_ORDER_NUM,po_header_temp.SAP_QUOTE#
FROM
po_header_temp
WHERE po_header_temp.PO_ID_REQ = PO_ID_REQ;
END;
But I am getting the following error .
4/25 PLS-00103: Encountered the symbol "(" when expecting one of the
following:
:= . ) , @ % default character
The symbol ":=" was substituted for "(" to continue.

5/16 PLS-00103: Encountered the symbol "(" when expecting one of the following: 
:= . ) , @ % default character 
The symbol ":=" was substituted for "(" to continue.

Reply to this discussion

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when other members reply.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: