It shows that you are unregistered. Please register with us by clicking Here
![]() |
|
![]() |
![]() | Register - FAQ - Today's Posts - New Posts - Support - Search | ![]() |
|
|
#1 (permalink) |
|
Junior Member
Join Date: Jun 2006
Age: 28
Posts: 16
|
I have successfully installed DBD::Oracle, however when running the query below I am seeing errors, can anyone tell me what Perl is complaining about?
SQL: my $sql = qq{SELECT FROM sched_table from def_tables where user_daily=’SYSTEM’}; Error: DBD::Oracle::db prepare failed: ORA-00936: missing expression (DBD ERROR: error possibly near <*> indicator at char 7 in 'SELECT <*>FROM sched_table from def_tables where user_daily=’SYSTEM’') [for Statement "SELECT FROM sched_table from def_tables where user_daily=’SYSTEM’"] at ./dbscript.pl line 26. Many Thanks, Andrew |
|
|
|
|
|
![]() |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Oracle Forms migration problems | jordan | Programming | 0 | 08-01-2006 06:31 PM |
| Problems in upgrading from Oracle 8 to 9i | zachary | Programming | 0 | 07-29-2006 04:21 PM |
| new to oracle | aaron | Programming | 0 | 07-29-2006 03:42 PM |
| Need help connecting to a Oracle DB | lauren | Programming | 0 | 07-04-2006 07:16 PM |
| Perl & Oracle Database; vcvars32.bat | sebastian | Perl | 0 | 07-02-2006 01:04 PM |