Problems with SQL*Plus and Stored Procedures [message #35814] |
Wed, 17 October 2001 02:09 |
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 #35820 is a reply to message #35814] |
Wed, 17 October 2001 07:57 |
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;
/
----------------------------------------------------------------------
|
|
|