 |
 |
Find a programming school near you
php-db | 2001011
Date: 01/08/01
- Next message: Julio Cuz, Jr.: "[PHP-DB] Open Client"
- Previous message: Dean Bennett: "Re: [PHP-DB] problem installing PHP3.0.16 or PHP4.0 with Sybase 11.9.2 and Apache 3.0.16 on RH 6.2"
- In reply to: Unimed de Capivari: "[PHP-DB] CALL A FUCTION OF ORACLE IN PHP?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
On Mon, Jan 08, 2001 at 02:22:33PM -0200, Unimed de Capivari wrote:
> I HAVE THIS STORED FUNCTION.
> HOW I CALL THIS FUCTION OF ORACLE IN PHP?
>
>
>
> CREATE function F_PARAMETER(PCDPARAMETER IN VARCHAR2) return varchar2 is
> Result VARCHAR2(60);
> begin
> -- Function F_PARAMETER
> -- Return THE VALUE FROM PARAMETER
>
> BEGIN
> SELECT VLPARAMETER INTO RESULT
> FROM PARAMETER
> WHERE CDPARAMETER = PCDPARAMETER;
> EXCEPTION
> WHEN NO_DATA_FOUND THEN
> RAISE_APPLICATION_ERROR(-20001,'Parameter '''||PCDPARAMETER||''' not found');
> when Others then
> RAISE_APPLICATION_ERROR(-20001,'Error searching Parameter '''||PCDPARAMETER||'''');
> END;
>
> return(Result);
> end ;
>
>
> Regards,
> Marcos
BTW no reason to YELL AT US!
<?
$conn = ocilogon("scott","tiger");
$stmt = ociparse($conn,"begin :THIESO := 2; end;");
ocibindbyname($stmt,"THIESO",$a,32);
ociexecute($stmt);
var_dump($a);
?>
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe <email protected> For additional commands, e-mail: php-db-help <email protected> To contact the list administrators, e-mail: php-list-admin <email protected>
- Next message: Julio Cuz, Jr.: "[PHP-DB] Open Client"
- Previous message: Dean Bennett: "Re: [PHP-DB] problem installing PHP3.0.16 or PHP4.0 with Sybase 11.9.2 and Apache 3.0.16 on RH 6.2"
- In reply to: Unimed de Capivari: "[PHP-DB] CALL A FUCTION OF ORACLE IN PHP?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
