Answer / 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;
--

ORA-31639: unexpected data found

1 Answers  

---

PCC-00092: Length and/or scale incompatible with specified Oracle datatype

1 Answers  

---

ORA-19762: invalid file type string

1 Answers  

---

PLS-00504: type string_BASE may not be used outside of package STANDARD

1 Answers  

---

QSM-00780: the task string could not be executed because the workload string is being modified

1 Answers  

---

ORA-12345: user string lacks CREATE SESSION privilege in database link (linkname string)

1 Answers  

---

ORA-07468: spwat: mset error, unable to set semaphore.

1 Answers  

---

ORA-25189: illegal ALTER TABLE option for an index-organized table

1 Answers  

---

NZE-28808: Cannot retrieve method information from the configuration file.

1 Answers  

---

NID-00403: DBNEWID - Completed with validation errors.

1 Answers  

---

ORA-31651: communication error with master process - detaching job

1 Answers  

---

ORA-39033: SUBQUERY data filter is inconsistent with direct path

1 Answers  

---