View with parameters
Posted by:
pao pao
Date: January 15, 2008 03:38PM
How can I create views with parameters?
example
CREATE VIEW `db_collaudo`.`VWX`(IN PID INT) AS
SELECT * FROM foo where id=PID;
this gets error.
With a stored procedure I can, but How car I call the result of a stored procedure within for example an INSERT statement
example
INSERT INTO TABLE
SELECT * FROM (CALL storedProc1());
this gets error.
How can I do that?
Subject
Written By
Posted
View with parameters
January 15, 2008 03:38PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.