• pl/sql ref cursor question

    Hi, I'm trying to figure out if this is possible in Java OPTION 1 ================== 1. Obtain a ResultSet by querying a non-oracle database 2. Cast the resultSet into an OracleResultSet 3. Pass the OracleResultSet into a pl/sql stored procedure for processing OPTION 2 ================= 1. Obtain a...

    Ajhaveri0 pointsBadges:
  • Automatically Populating a Date Field in a Table

    Can you please forward me an example of a trigger or some other means on how I can update a date field (e.g., DATE_COMPLETED) in a table when another field (e.g., EDITS_COMPLETED) within that same table has been populate with a particular value (YES)

    SamAvella30 pointsBadges:
  • Using LIKE with Variable Value not Literal Value….INSTR not optional

    I'm trying to build a search type select statement constrained by a users input.....variable(x) which forces the use of like in the selection processing: x := (whatever user enters); I have tried with no luck: Select * from personnel where lastname like '%x%'; Select * from personnel where lastname...

    BAdams20 pointsBadges:
  • ora-12154

    I'm new to Oracle so forgive me if I don't have all the terminology down, but I've installed Oracle 10g and I'm constantly getting an "ora-12154 Could not resolve the connect identifier" error at step 12 in database configuration assistant. I beleive it has something to do with the tnsnames.ora...

    Wilson630 pointsBadges:
  • Oracle Application or Database on its own server.

    Which would increase performance more. Moving an Oracle demand planning and forcasting application or an Oracle database onto its own server and or a faster server? There is some debate among myself and a couple of coworkers. I feel that the workhorse of Oracle is the database and that it should be...

    Ktharrell0 pointsBadges:
  • cannot drop the user

    Hi, I cannot drop the user. dorp user "USERA" cascade; ORA-01940: cannot drop a user that is currently connected But when I check v$session table. I do not see any USERA. This happens on me several times and every time when I face this, I need to restart my database. Is there any better method to...

    Cassidy6o60 pointsBadges:
  • HELP : I retrieve a blank page with UTL_HTTP in a request to a server which listen in a different Port than 80

    Dear colleagues I have a problem because a developer form our team, has a problem to retrieve a webpage in Oracle Portal whit UTL_HTTP. If he attempts to retrieve a webpage (pending to Oracle Portal) by a PACKAGE whit the next sentence: URL_TABLE := utl_http.request_pieces(p_website, 99999,...

    Onacorpuscle0 pointsBadges:
  • Running a script at specified runtime

    I am creating an Oracle Developer form which will take the query created by the user and specified runtime (also by user) and saves it in two columns of a Oracle table. Is there a facility in oracle which can trigger off the saved query when the sysdate becomes equal to specified runtime? Thanks

    Columbus0 pointsBadges:
  • Can’t login as Administrator

    Hello Everybody, I can't login to adminstrator profile in my standalone win 2000 adv server. I use this system for my study purposes. What happened actually is when I was shuting my system, it got powered off because of some UPS problem and the next time when I logged in using Administrator, it...

    BinooDas123410 pointsBadges:
  • Exporting from Access to Outlook

    I have some fields in an Access database that I want to use in Outlook. I want to take the First name, last name and email fields from this table and put them into my Contact List in Outlook. Is there an easy way to do this? I have tried exporting the db1 file and importing it but I get an error....

    Jade057110 pointsBadges:
  • Using Secure Shell (ssh)

    I have to submit a remote command from the AS/400 to run on a UNIX system. I am told by security admin. that I can only use Secure Shell(ssh). Both the AS/400 and the UNIX server are within the firewall. I do not know where to start. Does OS/400 V5R3 have this capability? Do I need additional...

    Ashnirody100 pointsBadges:
  • How to execute iSQL*Plus script from Oracle Portal

    I want to execute a SQL*Plus script which ask for parameters and updates an Oracle table from Portal. Any suggestions on how to do this? Thanks Bonita Graupe

    Ws8oBPSQ15 pointsBadges:
  • Oracle 9i upgrades

    I have an ORACLE_HOME installation /opt/oracle/9.2.0.4 and will upgrade this to 9.2.0.6 using the appropriate patchset. First running the Installer and then the sql scripts to update my database. When complete how do I change my ORACLE_HOME to reflect the new version e.g. 9.2.0.6 and what are the...

    Cbr10000 pointsBadges:
  • Database BackUp

    Hi e'rybody! I have recently started my new task as a Database Administrator in SQL 2000 after attending a week course DB administration. Well, we have our back ups running through the DB Maintanance and have noticed that some back ups increase too quick in size and as a result an average database...

    DibyDineo0 pointsBadges:
  • Read Only Document Question

    Scenario: We have a Word document that is our Facility Calendar. The secretary updates it as requested with meetings, seminars, etc. The problem: When someone else has the document open, she cannot save changes she makes. She then has to email everyone and tell them to close the document. Details:...

    TheVyrys0 pointsBadges:
  • Network Resource Allocation cum Planning cum Technical Problem

    This is the real commercial problem face by my company. Well, the reason I ask this problem is I salute and respect all of you as I believe all of you are as good as network solution company out there, or even better!! Lets me rephrase the entire problem again. Company expand so fast that the IT...

    Hunkgym5 pointsBadges:
  • Oracle ODBC Drivers from Oracle vs. Microsoft

    I am wrestling with whether Microsoft products (e.g., Excel-MS Query) that use ODBC to access Oracle databases would benefit more by using the latest driver from Oracle or Microsoft. If using a driver from Microsoft, is it likely to be significantly less efficient in exploiting the latest features...

    RNJ5090 pointsBadges:
  • Error on installing Oracle 10 software where Oracle 9i software already exists

    Folks, I am working on a Solaris Sparc server trying to install Oracle Enterprise Edition Software. This server already had Oracle 9i software installed. I am setting the ORACLE_HOME by writing on the command line: export $ORACLE_HOME=/oracle/10g. When I echo $ORACLE_HOME I get a return of...

    Wbuker0 pointsBadges:
  • End Program – explorer.exe

    From the last few days I am facing this problem. When I shut down my Win 2000 Server(SP4) at the end of the day the end program-exlorer.exe dialog box comes up twice and it shuts down only after I click on the 2 end now buttons. Both end program dialog boxes are same and comes one after another....

    BinooDas123410 pointsBadges:
  • End Program – explorer.exe-2

    From last few days I am facing this problem. When I shut down my Win 2000 Server(SP4) at the end of the day the end program-exlorer.exe dialog box comes up twice and it shuts down only after I click on the 2 end now buttons. Both end program dialog boxes are same and comes one after another. The...

    BinooDas123410 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