No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
Hi all, I m converting stored proc from sql server to oracle. first have a look sql stored proc. create procedure xyz.. as begin -- i have created one temp table -- then inserted some data into it by select query over some db table. -- then i have another … |
|
Hi friends, i got this err while executing this procedure. err is like this:- ----------------------------------------------------------------------------- 9/3 PL/SQL: Statement ignored 9/13 PLS-00201: identifier 'DATEADD' must be declared 11/3 PL/SQL: Statement ignored 11/13 PLS-00201: identifier 'DATEADD' must be declared ------------------------------------------------------------------------------ Please have look my stored procedure CREATE OR REPLACE PROCEDURE GReptExprtCompliTestRelt(EntityFolderCode number, … |