Hi, I got this error while calling a web service from the database. HTTP request failed ORA-29270: too many open HTTP requests. Any help will be appreciated.
Question
Oraask Latest Questions
Question
Hello guys, i want to know the main difference between oracle searched case & simple case statements?
Question
hello guys, please help me to know what is concatenation symbol in plsql.
Question
Hi, Can someone tell me what is the difference between Views and Materialized Views in Oracle? Thanks.
Question
suppose we have created new directory on database server and give it required privileges like : [code]CREATE OR REPLACE DIRECTORY TEST_DIR AS '/usr/tmp'; GRANT READ, WRITE ON DIRECTORY TEST_DIR TO MYUSER;[/code] Now i want to know if oracle has capable to read and ...
Question
for example I have one table with unique constraint on ID column and it has values like this : ID Name 1 test and I want to catch and handle unique constraint exception. thanks
Question
hello, I'm using Oracle 10gR2 and i want to know what's the differences between both because I take a look at the documentation and i find out there no differences. any suggestions will be appreciated.
Question
How to drop all partitions from all tables belonging to this schema based on date Hi, I have a script to delete the partition from a table which meet certain criteria and this the block of code to do this : DECLARE v_sql varchar2(500); v_date ...
Question
I face this error when I want to execute this block of code in an anonymous pl/sql block: DECLARE BEGIN SELECT last_name INTO v_last FROM employees; dbms_output.put_line('v_last is :' || v_last ); END; PLS-00201: identifier must be declared thanks.
Question
please i want to know all differences between procedure and function in oracle pl/sql thanks in advance.