[GENERAL] getting no days problem

2009-01-29 Thread sanjeev kumar
Hi all, I have written procedure as follows: - --procedure begin Create Procedure sp_getNoOfDays( ip_startDateIN date, ip_endDate IN date, op_noofdays OUT

[GENERAL] temporary table problem

2009-02-13 Thread sanjeev kumar
Hi, I am using EnterpriseDB(8.1) here is my individual procedure code written as like: Create or replace Procedure sp_leaveSummary( op_viewSummary OUT sys_refcursor, op_errormessage OUT varchar