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-27369: job of type EXECUTABLE failed with exit code: string

1 Answers  

---

ORA-01981: CASCADE CONSTRAINTS must be specified to perform this revoke

1 Answers  

---

PLS-00644: character set mismatch found at 'string' among result expressions in a CASE expression

1 Answers  

---

ORA-02466: The SIZE and INITRANS options cannot be altered for HASH CLUSTERS.

1 Answers  

---

ORA-24009: invalid value string, QUEUE_TYPE should be NORMAL_QUEUE or EXCEPTION_QUEUE

1 Answers  

---

ORA-06757: TLI Driver: server got bad command

1 Answers  

---

TNS-01150: The address of the specified listener name is incorrect

1 Answers  

---

SQL*Loader-00806: unknown record format specified for data file

1 Answers  

---

ORA-03200: the segment type specification is invalid

1 Answers  

---

LSX-00343: "~S" is not nillable

1 Answers  

---

PLS-00392: Type mismatch in arguments to BETWEEN

2 Answers  

---

ORA-12911: permanent tablespace cannot be temporary tablespace

1 Answers  

---