Hi there,
I am trying to run an oracle script with the OracleScript component and am getting a ORA-01008 error. However, I search the variables and set them:
VarList:=TStringList.Create;
AdvMemo.Clear;
VarLIst:=FindVariables(OracleScript1.Lines.Text,False);
For i := 0 to...
Hi there,
when I have DesignConnection to true and my app is started on a machine that has a different tnsname than the app hangs a bit and then dissapears complete from processes. On a machine that has the samen tnsname the app works fine... I am using a Oracle 8 client and Oracle 9 server and...
Thanks for pointing me in the right direction. This is the solution for my problem:
SQLPLUS> connect sys/manager as sysdba;
SQLPLUS> shutdown immediate;
SQLPLUS> startup mount;
SQLPLUS> alter system enable restricted session;
SQLPLUS> alter system set job_queue_processes=0;
SQLPLUS> alter...