Home » SQL & PL/SQL » SQL & PL/SQL » Problems with SQL*Plus and Stored Procedures
Problems with SQL*Plus and Stored Procedures [message #35814] Wed, 17 October 2001 02:09 Go to next message
Antonio
Messages: 12
Registered: October 2001
Junior Member
Hi,
I have Oracle 8i, and i need create a stored procedure.
When i have the script with the create and execute in SQL * Plus, it don´t create the procedure.
¿there are some problem?
Exmaple
CREATE OR REPLACE PROCEDURE INSERT_PRUEBAS_POLICY (
PARAM_ID OUT VARCHAR2,
ID_PRUEBAS IN NUMBER
) AS
BEGIN
SELECT CN_PRUEBAS
INTO PARAM_ID
FROM m_pruebas
WHERE id_pruebas = ID_PRUEBAS;
END INSERT_PRUEBAS_POLICY;

Thanks

----------------------------------------------------------------------
Re: Problems with SQL*Plus and Stored Procedures [message #35815 is a reply to message #35814] Wed, 17 October 2001 02:36 Go to previous messageGo to next message
André V.B.
Messages: 1
Registered: October 2001
Junior Member
END;

to final procedure.

----------------------------------------------------------------------
Re: Problems with SQL*Plus and Stored Procedures [message #35820 is a reply to message #35814] Wed, 17 October 2001 07:57 Go to previous message
Hans
Messages: 42
Registered: September 2000
Member
i think you forgot the /
 
CREATE OR REPLACE PROCEDURE INSERT_PRUEBAS_POLICY (
 	PARAM_ID OUT VARCHAR2,
 	ID_PRUEBAS IN NUMBER
) AS
BEGIN
 SELECT CN_PRUEBAS  INTO PARAM_ID  FROM m_pruebas
 	WHERE id_pruebas = ID_PRUEBAS;
END INSERT_PRUEBAS_POLICY;
/


----------------------------------------------------------------------
Previous Topic: pl/sql qestion
Next Topic: Why seqences cant be done this way
Goto Forum:
  


Current Time: Thu Mar 28 06:13:09 CDT 2024