• Passing PL/SQL Table As Parameter.

    Hi, I want to call the procedure returning PL/SQL table from java. What is the relevant datatype that can be used in java? Following is the code for the PL/SQL table procedure created - CREATE OR REPLACE PACKAGE test_plsqltable AS TYPE EmpTabTyp IS TABLE OF emp.empno%TYPE INDEX BY BINARY_INTEGER;...

    Techanalyst100 pointsBadges:
  • sqlloader problem while loading from a huge csv file

    Hi all, I am new to this community. Hope to have a great learning experience here. The error I am receiving while loading a huge file is: SQL*Loader-510: Physical record in data file is longer than the maximum(1048576) Actually the csv file I am loading from is huge, has 9lac+ records. Increasing...

    Avishek0 pointsBadges:
  • Remote Laptop Account Lockouts

    We use a draconian policy of 3 logon attempts before lockout, no reset, lockout forever, and force this to all devices connected to W2K domain. When laptops are used remotely, users being users invariably lockout their account and then either have to bring it back to be unlocked, or support visits...

    Rsg2590 pointsBadges:
  • Bad response time for first invocation of stored procedures in DB2400

    Platform: V5R3 Problem: A stored procedure takes about 1 to 2 minutes for the first invocation (No difference in this timing for green screen or i-series navigator or Java call through QZDASOINIT jobs). Subsequent invocations are wicked fast with subsecond response times Other info: Procedure takes...

    OracleInterface0 pointsBadges:
  • Restoring patch from 8.1.7.4 to 8.1.7.2. Verify steps

    Hi all, just need to verify if restore is required after a successful patch upgrade from 8172 to 8174, what are the steps? 1. restore the old oracle binaries 8.1.7.2 only. Will this work? Does the patch upgrade change header information, and oracle dictionary. If this is the case, then binary...

    Dannyl0 pointsBadges:
  • bios upgrade

    hi friends i have pII motherboard with chipset 1440lx while booting it give American megatrends Amibios (c)1996 American megatrends inc EX98 ver 1.06 (11/10/1998) in down stare 61704800 100000111111 071595 i440lx 6dlxn704h i have purchased 40gb harddisk but it is detecting 33gb i want to upgrade...

    Rpvish0 pointsBadges:
  • tuning

    I have a program which is run on an ad-hoc basis....the database is mainly a read only dB, i.e. not much inserts/updates/deletes. The process basically reads tables, then creates temporary oracle tables, creates indices on these tables and then does some inserts. The temporary oracle tables are...

    Fitzdp0 pointsBadges:
  • Creation of a new schema in Oracle

    My DBA insists that there isn't a role or privillige for create schema, from the research gathered so far there's clear indication that there should. What is the snytax for creating a new schema? The DBA isn't that he can only create a user not a schema

    Mnm1870 pointsBadges:
  • SqlDumpExceptionHandler Error Message In MS SQL Server 7.0

    I am trying to restore a database in MS SQL Server 7.0. I keep getting the following error message. Backup or restore operation terminating abnormally. SqlDumpExceptionHandler: Process 8 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. I...

    Bkr0963c0 pointsBadges:
  • Moving Log Files in Oracle 9.2.0

    Hi there i have 5 log groups in oracle 9.2.0. (running on win2k) my 3 log groups are all created under D: drive as i used oui to install my db. i had 16 hard disks,and the senior dba had asked me to move the 2 log groups to other hard disk. the configuration for my log groups (each w 3 mbrs) are as...

    Mayleong0 pointsBadges:
  • Help

    What does "DOU" mean?

    Daniellem0 pointsBadges:
  • The UNIX Idiot

    Hi everybody i'll be attending the Oracle10g upgrade course @ Oracle Corporation next week. I need some help with UNIX commands that a DBA could use(i was trained in Win mode for Oracle). Just abt 5-10 will do, coz i just need to survive the 5-day course. The Senior DBA at my company suggest that i...

    Mayleong0 pointsBadges:
  • IT Security

    Hi all, Thanks to all those who answered to my question"FTP sites" Can anyone of you let me know about the available products that we can use for our organisations IT security..Also let me know what products are available to find out vulnerabilities in a network. Appreciate your response. Thanks...

    Tarang0 pointsBadges:
  • Securing FTP on an Enterprise wide basis

    One of the recent questions here in the SeachWindowsSecurity.com ITKnowledge Exchange was stated the poster had blocked email services with a Proxy server so that internal employees could not obtain yahoo, AOL, and other external sources of security threats and the poster wanted further support in...

    CasR22070 pointsBadges:
  • Bad logon Event type 529

    A User ill advisedly switched off Anti-Virus and since then we see a failed logon (Type 4 - Batch)under Logon process Advapi every 15 minutes in his User Id. A search of the Web links this to possible virus infectection (Netdevil 1.2. We have scanned etc but can't track down what is generating the...

    Cripdan0 pointsBadges:
  • cics internet web interface question

    Good day, We are in the process of changing the CICS internet login protocol from basic to form based authentication. This requires placing a token inside the HTML referencing the item '&QUERY_STRING' as defined on page 80 of the CICS Internet Guide. Nothing is mentioned concerning the format of...

    Jeffer0 pointsBadges:
  • Implementing and configuring VPN Server

    Hello, Shiraz, I want to implement n configure VPN Server, so that my mobiles users and employee can access there file and network through Securely VPN Connection. Can any body help me out of this.. I need complete n detailed about VPN Configurations. What Hardware n software do i need to have...

    OnlineTechSupport0 pointsBadges:
  • Installing Seperate Internet Connection for Managers

    Hello, Myself shiraz, I got one problem. There are Five Floor in one Office which has Switches COnneted to each floor. They are getting LAN and WAN Connection through Centralized Wireless Server Room. Also We have access point to get connectivity from Head Office, which is just near to us. And that...

    OnlineTechSupport0 pointsBadges:
  • Need guidiance from pros already into the game

    Hi, I am a United Stated Marine stationed overseas since 2003, majoring in Information technology with National University. I am still an idiot in the field and thats why i joined this group. To get a glance of what to ecpect in the future. I am asking for your help in guiding me through whatever...

    Foguno0 pointsBadges:
  • Library management system

    i need a free library management system running on window or linux that can keep track of who has what cd/books any one help plse

    Eduado0 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following