• Calling a SQL Server 05 Stored Procedure from Oracle

    Is it possible to call a SQL Server 2005 stored procedure from Oracle? If the sp is called get_item_desc and has one input parameter (item_id), what might this call look like? Any help most appreciated!

    Nikkipom795 pointsBadges:
  • Oracle Enterprise Manager login password error

    We have windows 2003 server and we are running 2 oracle databases in version 11g. We were successfully configured EM for one database and when we were tried for the other database we encountered configuration errors and we were able to sort by searching on "google", solution was "ocijdbc10 file has...

    PKSDBA5 pointsBadges:
  • INSTR ()

    Hi Experts, My test case s working fine for the INSTR() but the same if i use in implemenation its not raising the error giving below the pseudo code IF INSTR (v_lm,pcd,1,1) = 1 OR INSTR(vlm,pc,1,1) = 1 OR INSTR(vlm,pcn,1,1) = 1 THEN raise_application_error( err_pkg.nt_val, err_pkg.nt_val_msg ||...

    Inprise610 pointsBadges:
  • Oracle connectivity with Oracle Forms 6i

    I am a new Oracle Form6i user. i ve installed Oracle form 6i in d:\Orant. now i need to work on form builder. there when i go with the wizard then i browse the table name it ask me with username :scott password : tiger database: so i have the problem what database name should i enter there. can...

  • How to determine Receipting tables linked to PO Line

    What are the receipting tables linked to PO Line (Header, Shipment, Distributions)?

    Jherb335 pointsBadges:
  • Lotus Notes to Oracle

    i have a field (date)i want to insert date(field) in oracle table .i used"+doc.date(0)+"but date is not inserted in oracle table . how can it possible .pls suggest me.

    Oraclelotu10 pointsBadges:
  • oracle log for table update infimation

    I am a system Administrator, I am having Oracle 10g database server on windows 2000 server in my office LAN network front end is forms & reports 6i. in last 10days 1 user connected to oracle database other than regular forms 6i program and modified one table record column value by update. How can i...

    Mbv30 pointsBadges:
  • Bulk Collect loop and Cursor Loop

    Why there is such a huge performace difference between Collection loop and a cursor Loop? Why collection populated using Bulk collect is way faster? Detailed explaination will be helpful. Thanks

    Nikhildhar35 pointsBadges:
  • What should our next contest be on ITKnowledgeExchange.com?

    We want to kick off the new year with an exciting contest and want your input. We have done a variety of contests from the top 3 Knowledge Point earners winning prizes like an XBOX 360. Also we have had Amazon.com gift cards for the top 10 point earners who achieve over 500 Knowledge Points. I want...

    ITKE345,295 pointsBadges:
  • How to write a test case in PL/SQL

    Hi Experts, How to write a test case in PL/SQL to check whether the parameter of a procedure (eg email iddress) takes only lower case ,i did this way in my procedure If(emailadd) <> lower(emailadd)then raise_app_error_ But this can be checked n test case please guide me with pseudo code...

    Inprise610 pointsBadges:
  • BACKUP & RECOVERY for Oracle 9i

    How can i take a backup of my database through OEM ? PLZ reply ASAP

    NehaArya55 pointsBadges:
  • querying detail records

    how do I query a detail record in a master-detail Oracle 6i form

    Kobi5 pointsBadges:
  • Hyperion Planning Delivered Reports

    Straight off the shelf, what reports and forms come already configured for Hyperion Planning and Hyperion Planning ETL?

    Purple5 pointsBadges:
  • Clustering

    I am using Oracle 10g on Windows I would like create clustes for faster reterival. How can I create it(syntax) can you help me with an example. How does it effect the performance

    Vishwanathavn5 pointsBadges:
  • Oracle 10g

    What's the best of breadth backup/recovery policy using RMAN 10g?

    Want2KnowOracle10 pointsBadges:
  • Oracle Streams

    What's the best checklist approach to implement schema data replication using Oracle Streams?

    Want2KnowOracle10 pointsBadges:
  • Calling an Oracle stored procedure in SQL Server

    I need to call an Oracle stored procedure from SQL Server. The stored procedure is written in ANSI SQL. ORCL is my linked server. I am calling ORCL.USER.PROCEDURE P1, P2, P3 and I am getting this error: Could not execute procedure 'PROCEDURE_NAME' on remote server 'ORCL'. [OLE/DB provider...

    SQL Server Ask the Experts2,585 pointsBadges:
  • stored procedure in delphi with oracle

    how to match the datatype of the field that is in database and the datatype of the variable that holds the value of the returned value from database using stored procedure.

    VPL100 pointsBadges:
  • ORA-12154 from Visual Studio

    I am getting ORA-12154 from Visual Studio 2005, when trying to connect to a database which I can connect to with SQL Plus.

    ChrisJay20 pointsBadges:
  • pl/sql procedure ,urgent!!!

    How to write a procedure for displying the data in a TREE or (PARENT and CHILD ) relationship , for ex: A is the main project id, for this project B,C,D are sub tasks(sub project id's) for B the sub tasks are e,f,g and for c is h ,i ,j and for d is k,l,m now i need to display the o/p in a TREE...

    Ecsbc35 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