Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2004
    Posts
    1

    Smile Unanswered: Help: DBD::Oracle::db prepare failed: ORA-24328: illegal attribute value (DBD ERROR:

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

    Cheers
    Sharada

  2. #2
    Join Date
    Dec 2004
    Location
    Argentina
    Posts
    2

    Unhappy I get the same error

    I get the same error and I can´t figure out what´s wrong.

    I have AIX 5.2, Perl 5.8.0, DBI 1.46, DBD::Oracle 1.16 and Oracle Client 8.1.7.4.
    I can run oracle packages but if I try any simple SELECT query it gives me the error: DBD::Oracle::db prepare failed: ORA-24328: illegal attribute value (DBD ERROR: OCIAttrSet OCI_ATTR_CHARSET_FORM).

    Anyone knows the solution?

  3. #3
    Join Date
    Jun 2004
    Location
    Nowhere Near You
    Posts
    89
    Quote Originally Posted by jasti_sharada
    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.
    Code:
    ---
    ---
    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;
    --
    --
    Cheers
    Sharada
    What happens when you use

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

  4. #4
    Join Date
    Dec 2004
    Location
    Argentina
    Posts
    2

    nothing happends

    This is my simple script:

    #! /usr/bin/perl -w
    use DBI;
    my $dbh = DBI->connect( xxx, xxx,
    xxx )
    || die "Cant connect: $DBI::errstr\n";


    print "Success!!!\n";

    my $sth = $dbh->prepare("SELECT * FROM dual") || die "Cant prepare: $DBI::errstr\n";
    $sth->execute();

    ### Now, disconnect from the database
    $dbh->disconnect
    or warn "Fail: $DBI::errstr\n";
    exit;

    When I execute this script in my development environment I get:

    DBD::Oracle::db prepare failed: ORA-24328: illegal attribute value (DBD ERROR: OCIAttrSet OCI_ATTR_CHARSET_FORM) [for Statement "SELECT * FROM dual"] at test_dbi.pl line 23.
    Cant prepare: ORA-24328: illegal attribute value (DBD ERROR: OCIAttrSet OCI_ATTR_CHARSET_FORM)

    But, if I try with other types of connection (SQLNav, SQLPlus, ...) the SELECT statement work fine.

    Could it be a configuration issue or a incompatibility issue?

    Cheers,
    Mariano

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •