Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2013
    Posts
    5

    Unanswered: PDO and temp tables

    I execute a stored procedure that creates a temporary table. I then execute my own query with a prepared statement that attempts to query the recently created temp table. I get the standard access violation/syntax error as if the table name is wrong. I'm doing this with the same connection executing two prepared statements in sequence.

    Does PDO not support this sort of thing?

  2. #2
    Join Date
    Mar 2013
    Posts
    5

    Error Mesage indicates temp table cannot be found

    SQLSTATE[42S02]: Base table or view not found: -206 [Informix][Informix ODBC Driver][Informix]The specified table (sda) is not in the database. (SQLPrepare[-206] at /opt/lampp/PDO_INFORMIX-1.2.7/informix_driver.c:131)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •