2
Sybase-CT bug #27843: notices when query is a stored procedure
4
<?php require('skipif.inc'); ?>
7
/* This file is part of PHP test framework for ext/sybase_ct
9
* $Id: bug27843.phpt,v 1.1 2004/07/11 16:31:32 thekid Exp $
14
$db= sybase_connect_ex();
16
// Check if stored procedure already exists
17
$sp_name= basename(__FILE__, '.php');
18
var_dump(sybase_select_db('tempdb', $db));
19
if (!sybase_select_single($db, 'select object_id("'.$sp_name.'")')) {
20
echo "Stored procedure {$sp_name} not found, creating\n";
21
var_dump(sybase_query('
22
create proc '.$sp_name.'
29
echo "Stored procedure {$sp_name} found, using\n";
33
// Execute stored procedure
34
var_dump(sybase_select_ex($db, 'exec '.$sp_name));
36
// Clean up after ourselves
37
var_dump(sybase_query('drop proc '.$sp_name, $db));
45
>>> Query: exec bug27843