Hello,

Today when I wrote a new stored procedure and inserted it into the
database.. the execution of the function from the stored procedure
through a php script is throwing the following error :

Warning: pg_query(): Query failed: server closed the connection
unexpectedly This probably means the server terminated abnormally before
or while processing the request. . in
/home/rajesh/public_html/inv/php/REPStockoutItems.php on line 65

This has started coming only for this stored procedure.. Other stored
procedure functions work perfectly... I could not make head or tail out
of this and why it is happening...

The error comes while executing the stored procedure function from php..

$sSql       = "select func_stockoutitems('$txtFromDate', '$txtToDate', 
'$txtDescription')";
$lResult    = pg_query($oConn, $sSql);


Similar kind of stuff is done in other scripts where stored procedure
functions are called and that is working without any problems...

Can anybody throw light on the above error and what could be the
probable cause ?

Thanks in advance...

Warm Regards


--
Rajesh



-------------------------------------------------------
This SF.net email is sponsored by: IBM Linux Tutorials.
Become an expert in LINUX or just sharpen your skills.  Sign up for IBM's
Free Linux Tutorials.  Learn everything from the bash shell to sys admin.
Click now! http://ads.osdn.com/?ad_id=1278&alloc_id=3371&op=click
_______________________________________________
linux-india-help mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/linux-india-help

Reply via email to