sanjeev kumar wrote:
Hi,
I am using EnterpriseDB(8.1) here is my individual procedure code
[snip]
Now my question is from DB side there's no error, But from UI (java) side
while calling the procedure
they are getting the null refcursor and as well as "op_errormessage" out
parameter getting th
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
IIRC, any things where you're doing creates/drops
in plpgsql pretty much mean you have to generate
the statements as strings and use EXECUTE which
will prevent the plans from being cached.
On Fri, 28 Sep 2001, Dinesh Parikh wrote:
> Dear all, I have a strange problem.Document says that one can
Dear all,
I have a strange problem.Document says that one can
create a temporary table in a session. I had created a temporary table in
languge plpgsql.(Actually in a procedure). After completing my task I droped a
table within a seesion(In same Function). Now problem arises. When I again
c
