S
snoopy_
Hello,
I am trying to use DBI to perform a select statement, but it's
choking with a format problem:
ORA-00923: FROM keyword not found where expected (DBD ERROR:
OCIStmtExecute/Describe)
Could this be an issue with using vertical bars?
Select statement is as follows:
my $sql = qq{
select 'user|' || up.user_name || '|' || up.base_db || '|' || up.dept
|| '|' || up.group_id
from pcms_workset_info wsin, pcms_users_profile up
where up.user_name = UPPER ('$user_name' )
and up.privilege_level = 0
minus select null from dual
};
I am trying to use DBI to perform a select statement, but it's
choking with a format problem:
ORA-00923: FROM keyword not found where expected (DBD ERROR:
OCIStmtExecute/Describe)
Could this be an issue with using vertical bars?
Select statement is as follows:
my $sql = qq{
select 'user|' || up.user_name || '|' || up.base_db || '|' || up.dept
|| '|' || up.group_id
from pcms_workset_info wsin, pcms_users_profile up
where up.user_name = UPPER ('$user_name' )
and up.privilege_level = 0
minus select null from dual
};