I want to create a stored procedure that takes the following information and
puts it into a table. How would I do this?
CREATE OR REPLACE Procedure Used_license as
Begin
Select A.Pc_session_id From pt_client_event A where A.pc_event_op = 'LAUNCH'
and A.pc_date =SYSDATE -1
minus
Select
I think you need a ; at the end of the select statement.
-Original Message-
Sent: Wednesday, January 23, 2002 6:20 PM
To: Multiple recipients of list ORACLE-L
I want to create a stored procedure that takes the following information and
puts it into a table. How would I do this?
You used an incorrect name for the procedure. Here
is one that compiles flawlessly:
CREATE OR REPLACE Procedure RTFM
Begin
Select A.Pc_session_id From pt_client_event A
where A.pc_event_op = 'LAUNCH'
and A.pc_date =SYSDATE -1
minus
Select B.Pc_session_id From pt_client_event B
recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Fax to:
Subject:creating a procedure
I want to create a stored procedure that takes the following information
and
puts it into a table. How would I do this?
CREATE OR REPLACE Procedure Used_license as
Begin
Select
Title: RE: creating a procedure
-Original Message-
From: Lance Prais [mailto:[EMAIL PROTECTED]]
I want to create a stored procedure that takes the following
information and
puts it into a table. How would I do this?
CREATE OR REPLACE Procedure Used_license as
Begin
Select
I am not one to usually shout RTFM from the mountain top, but I somehow feel
compelled because I have read a couple of responses that hadn't mentioned
that age old mantra.
Your procedure might be salvagable by putting a ; at the end of your select
statement, but I don't believe it will do