• Executing a Function or Procedure from ouside Oracle

    I have verified the code below as a valid Function and it executes from TOAD. It does not work if called from: SELECT F_T_TOTALE_TO_T_SCRAP_SC(V_TIRE_ID_EXTRACT) FROM T_TOTALE The Error is 14551. I have researched this error and it states that a function cannot be executed from a SELECT statement...

    Moonmullins0 pointsBadges:
  • VB.Net of Visual Studio.Net 2003 VS Visual Basic 2005 Express Edition

    Good Day! Would be appreciate if there is solution for the following problem: - In VB.Net of Visual Studio.Net 2003, developer can click and drag a table listed in the Server Explorer from a connected database to the form. This will add OleDbConnection control and OleDbDataAdapter control to the...

    Hunkgym5 pointsBadges:
  • problem in installing the second oracle home

    Hi all, Iam having problem in installing the second Oracle_Home to install my SAP Test server , iam already having one Oracle_Home configured which is for my development server on the same box which should not be disturbed. In the Oracle Universal Installer iam giving the Oralce_Home and the path...

    Basis50 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:
  • Configuring isql *plus

    Hi, I want to configure isql *plus in my oracle server. Can any one give me the configuration steps to invoke the isql * plus in my oracle server. Thanks in advance, Regards, P. Karthik

    Oraworld0 pointsBadges:
  • Oracle 9i Reports Developer

    I'm trying to open the Reports Builder 9i on my Windows XP Prof. SP1. The problem is that I can see the Reports Builder Start Screen and thats all. It always hangs at that point. I can open Oracle Forms Builder and everything else in the Developer Suite.

    Gboyd40 pointsBadges:
  • Difference between length and vsize functions

    Hi I have got same results for both the vsize and length functions. Why the two functions are giving the same result? Can any one clarify this? Thanks in advance, Regards, P. Karthik

    Oraworld0 pointsBadges:
  • Import utility in Oracle

    When importing a table (as a means of restoring), and specify ROWS = Y, does the data in the table get overridden?

    Mayleong0 pointsBadges:
  • Configuring OEM to access Oracle on 2 systems

    Background: oracle_sid=opteldb runs on win2k v9.2.0 (IP=10.201.132.40) oracle_sid = GLDBWH runs on solaris 2.6 v8.1.7(IP:10.201.135.101) OEM is configured on win2k (client platform--not the oracle win2k server). I now can access opteldb and tnsnames.ora is configured with opteldb (stored in...

    Mayleong0 pointsBadges:
  • Trying to solve ORA-00980: synonym translation is no longer valid

    I ran the catalog.sql script on my Enterprise DB in preparation for exporting a schema from my Oracle 9i version 9.2.0.1.0 Enterprise DB with an Enterprise Manager Server and Intelligent Agent to an Oracle 9i version 9.0.1.1.0 Personal Edition DB(Each DB running on separate PCs in my LAN). I ran...

    Aascotty0 pointsBadges:
  • time-based & change-based recovery

    i was reading abt these methods of recovery. In classrooms, the lecturer always simulate this sort of recovery by noticing the time (for time-based recovery), or the log seq# (for changed-based recovery). In reality, there will always be careless users who deleted a record they shldnt and now...

    Mayleong0 pointsBadges:
  • Tablespace recovery

    Q1: How do i find out which datafile i need to recover when doing a tablespace recovery? Is it thru V$DATAFILE? Will oracle indicate this? Q2: Under which circumstances shld i consider recovering a datafile / a tablespace? It seems that i could recover a tablespace by just recovering a datafile (if...

    Mayleong0 pointsBadges:
  • Email alerts and export report to Excel

    I'm running oracle9.2 on win2k. I need to do the following: 1) Run a script to monitor my storage percentage,number of extents of a tablespace, free space. After which i need to email this report to myself via MS outlook so that i have a record of this. The email shld be on a daily basis. This is...

    Mayleong0 pointsBadges:
  • Naming Constraints and Moving Tables

    Hi i hv started on Oracle9.2 running on win2k. A consultant we hired wrote all the shop floor programs and define all the tables, indexes, constraints. He also define for us the database config (init.ora). Because he is more into programming, i need to "clean-up" his act 1)Move all my uses even SYS...

    Mayleong0 pointsBadges:
  • Oracle ./runInstaller problem

    Dear Oracle Experts, I came across the following problem when trying to update my Oracle 9.2 to Oracle 9.2.0.4 When I typed > ./runInstaller for the Oracle 9.2.0.4 patch. I get the following error. "You do not have permission to write to the inventory /oracle/product/db/920/$ORACLE_HOME....

    Asiankiwi0 pointsBadges:
  • Oracle 9i Instance and database creation from the command line in WIN NT 2000

    Hi, Has anyone done this using Windows Authentication (the user is an admin and in the ORA_DBA group)? I used oradim to create an instance and did not specify any password. Instance was created but it gave me a TNS-12156 : TNS Protocol Error while connecting "connect /as sysdba". When I specify a...

    Sumeshs0 pointsBadges:
  • Versioning and merging products for oracle

    Has anyone been working with/implementing any versioning products with merging capabilities for oracle pl/sql? I'm hoping for some recomendations.

    Cleveland0 pointsBadges:
  • SYS account problems with 9i

    Hi, When I try to login to the Oracle 9i database as sys, I am getting a TNS-12154 error. Surprisingly, I can log in as SYSTEM and another DBA account. The reason why I need to get in as SYS is to recompile the STANDARD package, as it has become invalid (?), ORA-6553 error and developers are not...

    Sumeshs0 pointsBadges:
  • CLOB – Fetch out of sequence

    I am inserting into a table which has a CLOB field. I insert a blank_clob and then try and retrieve the clob field again directly after insert. When I execute the select to retrieve the CLOB field I am getting ORA-01002: fetch out of sequence. The query looks like: select XML_DATA from XML_TABLE...

    GinaOL0 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