Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: vrudenko
  • Content: Threads
  • Order by date
  1. vrudenko

    Automating Web reports

    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
  2. vrudenko

    Oracle 8i&9i client on the same PC

    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.
  3. vrudenko

    Create database

    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...
  4. vrudenko

    CREATE TABLE STATEMENT

    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 ))...
  5. vrudenko

    UNIQUE CONSTRAINT

    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
  6. vrudenko

    TEMP TABLESPACE IS HUGE AND FULL

    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
  7. vrudenko

    Hi All, I am going to pass Oracl

    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
  8. vrudenko

    ORA-06502 Error

    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...
  9. vrudenko

    OEM doesn't show Error Messages

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

    NT operating system command from PL/SQL

    Hi, I need to execute Windows NT operating system commands from stored procedures (PL/SQL). Thank you for any help Vira
  11. vrudenko

    Analog for SQL Server xp_cmdshell in Oracle

    Please tell me an analog for MS SQL Server xp_cmdshell Extended Stored Procedure in Oracle 8i. I need to call the procedure within an Oracle stored procedure (PL/SQL). Thanks in advance Vira
  12. vrudenko

    CLOB problems

    Hi, I have to create a procedure that takes a part of the CLOB as parameter to search CLOB in a table. Can I and if it is possible how can I pass CLOB as parameter in a procedure? How can I search CLOB using the pattern? Thanks a lot for help in advance Vira
  13. vrudenko

    result set from a stored procedure

    Hello, I am using a result set from a stored procedure, like this: var c refcursor execute proc_name(:c) print c That works called in Oracle SQL*Plus. But I have to call it via ODBC from 4D (4th Dimension). Thanks in advance for any help Vira
  14. vrudenko

    How to return a result set from Oracle stored procedures via ODBC

    Hello, I am using a result set from a stored procedure, like this: var c refcursor execute proc_name(:c) print c That works called in Oracle SQL*Plus. But I have to call it via ODBC from 4D (4th Dimension). Thanks in advance for any help Vira

Part and Inventory Search

Back
Top