Search results for query: *

Tanks a lot!

I need make my Web reports run automatically in some time. Is it possible to create a script or some thing else and schedule running it? Thank you in advance

Thank you Turkbear!

Hi, I have Oracle 8.1.7 client on my PC (Windows 2000) and need also to install Oracle 9i client. Is it OK? Any conflicts can happen? Thank you in advance.

Hi, I need DBA's help. I tried to create database by using a script. I prepared init.ora file, created and run service and run SQLPlus and than tried to startup an instance: SQL>startup nomount pfile="my_init_ora" I got an error ORA-27100: shared memory realm already exists Please...

Hi MARCUS, I don't know how to catch cursor from Java but I can give you an example doing it in SQLPlus. First the cursor variable should be declared in a package to be a global one. CREATE OR REPLACE PACKAGE REF_CURSOR_TYPE AS TYPE RCT IS REF CURSOR; END REF_CURSOR_TYPE; CREATE OR...

Thank you Sem

Thank you sem!

Hi, I read from Metalink forum this syntax of CREATE TABLE statement: CREATE TABLE PR_DESC ( PR_DESC_ID NUMBER(10) CONSTRAINT PR_DESC_PK PRIMARY KEY USING INDEX (CREATE INDEX PR_DESC_PK_IDX ON PR_DESC (PR_DESC_ID) TABLESPACE INDX STORAGE ( INITIAL 128K NEXT 128K PCTINCREASE 0 ))...

Hi, Please answer me if a column can have UNIQUE and NOT NULL constraints together. Do not interfere Primary key constraint on another column with UNIQUE and NOT NULL constraints on this column then? Thanks in advance

Thank you!

Thank you for helping. But, I beg you to guide me further because I'm not DBA and my company doesn't have DBA. How can I drop segments and resize datafile? What are the steps and statements? Thank you very much in advance

Hi, I faced the problem with the Temp tablespace (Oracle 8.1.7, Windows NT4). It's very huge and full. Please give me some advise to clean it and decrease it's size. Thank you

Hi All, I am going to pass Oracle Developer certificate exams: 1.Developer 2000 Build FormsI (1Z0-121), 2. Build Internet ApplicationsII (1Z0-132). Help me please to find the best books and documentation to prepare. Tnanks in advance

I really appreciate all!!! Now it works. I used function arguments in the function body. After assigning them into local variables, the stored procedure executed correctly. But, I can't understand why it worked with restricted number of rows.

Thank you for help. I checked the length of values of the fields - the max=4. And the fields in the table CHAR(4). Any other adeas?

Hi, I'd like to explain a litle my problem. I created a cursor that has a function DEF_COST_CENTRE in select clause. The error occurs when I try to fetch data into a variable ERROR at line 1: ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at...

Hi all, When I try executing stored procedure that returns a big number of rows, I get the error: ERROR at line 1: ORA-06502: PL/SQL: numeric or value error: character string buffer too small. As I understand, I can increase the buffer by changing a parameter in INIT.ORA. IS it right? And...

Hi, My Oracle Enterprise Manager, v.2.2.0.0. doesn't show error messages in Error Messages Dialog Box. Please help!!! Vira

Hi all, Thank you for help! Unfortunately, my company does not have an Oracle DBA. So, I have to solve the question myself. Vira