Answer Posted / premalingam

Hi,
Can anyone help me in solving this error pls.
I am trying to execute a pl script in which it executes a
simple SQL statement "Select Client_loc_no from Subscriber".
I get this error and could not find out the reason why.

" DBD::Oracle::db prepare failed: ORA-24328: illegal
attribute value(DBD ERROR: OCIAttrSet OCI_ATTR_CHARSET_FORM)
[for Statement "SELECT Client_Loc_no from SUBSCRIBER
"] at taskupload.pl line 164."

Given is the code snippet of the script.

---
---
my ($dataSource) = "dbi:Oracle:host=$server;sid=PACD;port=1521";
$dbcdb = DBI->connect($dataSource, $user, $pwd) or die
"Cannot connect to $server using $user/$pwd!\n";

my($sql) = <<EOT
SELECT Client_Loc_no from SUBSCRIBER
EOT
;
my $sth = $dbcdb->prepare($sql) or die "Prepare statement: "
. $dbh->errstr;
--

How to resolve QSM-01108 error. I have no OR conditions in my query, but do have 9 IN conditions. The error says the max limit is 2 while I have 257 number of disjuncts. However, if I remove even a single IN condition, the query is rewritten. I cannot change my query. How can I resolve this issue?

2723

---

IMP-00096: Warning: Skipping table "string"."string" because type synonym "string"."string" cannot be created

1620

---

IMP-00064: Definition of LOB was truncated by export

6415

---

ORA-26032: index string.string loading aborted after string keys

2107

---

[ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454) Unsuccessful: alter table user.CEN_USER_MASTER add constraint FKF4EDEDC3D0BAAE75 foreign key (ROLE_ID) references user.CEN_ROLE_MASTER [ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454) ORA-02275: such a referential constraint already exists in the table

2731

---

ORA-07497: sdpri: cannot create trace file 'string'; errno = string.

2805

---

IMP-00060: Warning: Skipping table "string"."string" because object type "string"."string" does not exist or has different identifier

3169

---

ORA-26029: index string.string partition string initially in unusable state

2155

---

In my project I am using star schema and only diimension tables are loaded and not fact tables any one can help me why it is happening? Plase guide me.

2870

---

ORA-16626: failed to enable specified object

2218

---

ORA-26082: load of overlapping segments on table string.string is not allowed

1768

---

IMG-02003: 2FF03 - incorrect color histogram feature specification

1710

---

ORA-26094: stream format error: input column overflow

2808

---

ORA-26030: index string.string had string partitions made unusable due to:

1941

---

invalid quantity specification negative quantity are not allowed for this item please check this item definition quantity

3385

---