Oraperl problem

    I'm having problems with an oracle script. I can't seem to log onto oracle because the program can't find something called orlon. Any help would be appreciated. Thanks.

    Donner

• Program

  ---

  #! /opt/oracle/src/oraperl-v2.4/oraperl -w

# Specify Username

$user_name="snoopydog";

# Specify Password

$passwd="cic2";

# Specify Database

# $database='T:128.165.128.115/1525:pcsr';
$database='pcsr';

# Log on to Oracle

$lda=&ora_login($database, $user_name, $passwd) || die;

# Open a cursor and execute the querry.

$csr=&ora_open($lda, "select initcap(name), grp, email from phone_file where znu
m = '121870'") || die;

_at_results=&ora_fetch($csr);

# Close a cursor and
# Disconnect the database server

&ora_close($csr);
&ora_logoff($lda);

# Check if any results were found.

if(_at_results == 0)
  {
  print "No results found.\n";
  }
else
  {
  print "Results found.";
  }

• Resulting Output

  ---

  congress 22: ./testprog1
  1. | malloc: got ora_debug 34 bytes at 40018bc8
  2. <userinit
  3. >ora_login
  4. | entry: ora_login("pcsr", "snoopydog", "cic2")
  5. | >ora_getlda
  6. | | entry: ora_getlda(void)
  7. | | >ora_getcursor
  8. | | | entry: ora_getcursor(void)
  9. | | | malloc: got a cursor at 0x400215c8
  10. | | | malloc: got a csr at 0x40010888
  11. | | | exit: returning 0x400215c8
  12. | | <ora_getcursor
  13. | | malloc: got hda at 0x40012c08
  14. | | exit: returning 0x400215c8
  15. | <ora_getlda
  16. | >set_sid
  17. | | entry: set_sid(pcsr)
  18. | | info: setting ORACLE_SID to pcsr
  19. | <set_sid /usr/lib/dld.sl: Unresolved symbol: orlon (code) from ./testprog1 IOT trap (core dumped)

      ---

Again, thanks for your time. Received on Thu Jan 08 1998 - 00:00:00 CET