I'm getting this message when i try to run a query on an Oracle database
thru ODBC.
I can connect to the database just fine.
here is the code i'm trying to use.
$td_oracle = odbc_connect($dsn, $username, $password) OR DIE("Unable to
connect to oracle aradmin database");
$si_oracle_query = "SELECT * FROM SERVICE_INSTRUCTIONS";
$si_oracle_result = odbc_exec($td_oracle, $si_oracle_query);
the result i get is:
Warning: SQL error: [Oracle][ODBC Oracle Driver][Oracle OCI]ORA-00972:
identifier is too long., SQL state 37000 in SQLExecDirect in c:\program
files\apache group\apache\htdocs\odbc_test.php3 on line 34
i'm connecting to an MSAccess database thru odbc just fine and sending a
similar query, it works just fine.
do i need to do something different because it is an oracle database?
(I read somewhere that oracle uses ' and/or " for Identifiers) Is that on
the right track?
thanks!
-ken
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
