DBD::Oracle on Linux, moving to another machine

2002-01-30 Thread Stan Brown
yway that I can clone the workign DBD::Oracle from the other machine? I really only need teh new machine to be able to access remote databases using DBD::Oracle and SQLNet. Sugestiosn? -- Stan Brown [EMAIL PROTECTED]843-745-3154 Charleston SC. --

How to safetly check an SQL statement?

2002-01-09 Thread Stan Brown
of causing the script to bail out on an error? Oravle system tables. table tha -- Stan Brown [EMAIL PROTECTED]843-745-3154 Charleston SC. -- Windows 98: n. useless extension to a minor patch release for 32-bit extensions and a graphical shell fo

How to execute an Oracle PLSQL procedure with dbi?

2001-11-29 Thread Stan Brown
;execute index_reporting.index_report($pass)"); But that does not work. So what am I doing wrong? -- Stan Brown [EMAIL PROTECTED]843-745-3154 Charleston SC. -- Windows 98: n. useless extension to a minor patch release for 32-bit extensions and a graphica

Interactions between Tk::ErrorDialog and PrintError

2001-08-30 Thread Stan Brown
Could someone point me to some docs about the interaction between B+DBI's error messages & Tk::ErrorDialog? Perldoc Tk::ErrorDialog comes up with nothing on my machine. -- Stan Brown [EMAIL PROTECTED]843-745-3154 Charleston SC. -- Wind

Error handling questions

2001-08-30 Thread Stan Brown
, so that I can save it, and restore it to it's original value, after I make a local change to it? -- Stan Brown [EMAIL PROTECTED]843-745-3154 Charleston SC. -- Windows 98: n. useless extension to a minor patch release for 32-bit extensions a

Oracle specifc DBI question

2001-08-09 Thread Stan Brown
4,', '||substr(column_name,1,30),NULL)) || max(decode(position,15,', '||substr(column_name,1,30),NULL)) || max(decode(position,16,', '||substr(column_name,1,30),NULL)) columns from user_cons_columns b, user_constraints a where b.constr

PerlTk and _looong_ query

2001-08-08 Thread Stan Brown
this query is being procesded. Is there a way to "background" this query, and allow the callback to return to the main event loop? This must be a common situation with a well known solution, but I can't see it. -- Stan Brown [EMAIL PROTECTED]

How should I proerly quote dynamicly generated query?

2001-08-08 Thread Stan Brown
Given a dynamicly generated quer, what's the best way to provide appropriate quoteing before pasing it to prepare? -- Stan Brown [EMAIL PROTECTED]843-745-3154 Charleston SC. -- Windows 98: n. useless extension to a minor patch release for 3

Help referencing data structure retruned from fetchall_arrayref

2001-08-07 Thread Stan Brown
. -- Stan Brown [EMAIL PROTECTED]843-745-3154 Charleston SC. -- Windows 98: n. useless extension to a minor patch release for 32-bit extensions and a graphical shell for a 16-bit patch to an 8-bit operating system originally coded for a 4

Help with editing larg (very large ?) tables

2001-08-07 Thread Stan Brown
2. More robust (IE not liekly to exced system memory resources). Sugestions? -- Stan Brown [EMAIL PROTECTED]843-745-3154 Charleston SC. -- Windows 98: n. useless extension to a minor patch release for 32-bit extensions and a g

Re: Cross platform problems

2001-02-12 Thread Stan Brown
e code? -- Windows 98: n. useless extension to a minor patch release for 32-bit extensions and a graphical shell for a 16-bit patch to an 8-bit operating system originally coded for a 4-bit microprocessor, written by a 2-bit company that can't stand for 1

Cross platform problems

2001-02-12 Thread Stan Brown
exit; } } Any ideas what I am doing wrong here? If I connect from teh Linux box, and run the statement by had it returns one row, as expected. -- Stan Brown [EMAIL PROTECTED]

Help, please with getting DBD::Oracle working on Debian Linux

2001-02-09 Thread Stan Brown
ink called libclntsh.so. I am doing all of this loged in as the Oracle user, and $ORACLE_HOME is set in that envrionment. Also the scott/tiger accoun is still enabled. I desperatly need to get this working to move on with a project I am in a time crunch on. What should I try next? -- Stan Brown

Problems installing OracleDBD on Debian Linux 2.2 system

2001-02-08 Thread Stan Brown
ct file: No such file or directory at /usr/lib/perl5/5.005/i386-linux/DynaLoader.pm line 169. at (eval 1) line 3 at t/base.t line 19 The remaining tests will probably also fail with the same error. *** Please read the README and README.help files for help. *** FAILED tests 4-5 Failed 2/