[PHP] Cascading delete in oracle

[Raven Eve]

create table Shop(
ordId NUMBER(7) NOT NULL PRIMARY KEY);

create table Customer(
ordId NUMBER(7) NOT NULL,
FOREIGN KEY (ordId) REFERENCES Shop(ordId) on delete cascade);

so, when i delete a row in shop, the corresponding row in customer will be
deleted.

so, i have created a function in php to execute the query
whereby $sqlStmt = "Delete from Shop where ordId = $ordId";

function executeSql($sqlStmt) //line 524
 {

  //echo $sqlStmt;

   $this->stmt = OCIParse($this->conn, $sqlStmt)or die
("Sorry, cannot parse the sql statement. Please inform the webmistress of
the error messages");

   // verify that SQL is valid
   $this->checkErrors();

  OCIExecute($this->stmt, OCI_DEFAULT) or die //line 534
("Sorry, cannot execute the sql statement. Please inform the webmistress of
the error messages");

  $this->checkErrors();

  //commit to database
  $this->commit();

 }

however, when i tried to execute the sql stmt, an error stmt will occur :
Warning: Missing argument 1 for executesql() in
c:\apache\htdocs\project\ProcessSql.php on line 524

Warning: OCIStmtExecute: ORA-24337: statement handle not prepared in
c:\apache\htdocs\project\ProcessSql.php on line 534
Sorry, cannot execute the sql statement. Please inform the webmistress of
the error messages

This function works for tables that do not have cascading deletes.
How do i get round this problem? thanx :P
--




--




-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php