begin
coll.countStudent();
end;
The procedure countStudent contains sql that display the result of the query.
But I only get this message:
PL/SQL complete successfully
How to get t...
I'm experiencing this error in a PL/SQL routine that has not changed (for months) and that makes no rowid or "where current of" manipulations. The statement that fails is an update of one tabl...
Hello Experts,
Here is my sample procedure.....
==========================================
PROCEDURE MYPROC ( I_CNO IN NUMBER ) AS
TYPE t_Cursor IS REF CURSOR;
v_Cursor t_Cursor;
...
Hello,
Can you explain me the difference between oracle 8i and 9i and 10g also.
Thanks
I have Microfocus Cobol as a front-end to my Oracle7 database.
From my Cobol programs, I accept both the Oracle username and Password from the user. I use these 2 entries to connect to the th...
Hi,
simple sql plus question
how do you format the columns in the ouput of sql plus so I can read them nicely from left to right
and under to appropriate column names?
my ouput is as...
i am trying to find out size of table.
I used all_tables view to find size
select table_name, tablespace_name , avg_space, cache , INITIAL_EXTENT ,NEXT_EXTENT ,
MIN_EXTENTS ,MAX_EXTENTS...
Hello,
I would like to grant some privileges to a user for a whole schema. E.g. that USER2 has update-rights for all tables in SCHEMA1. Do I have to grant all tables step by step (GRANT UPD...
I am running impdp on a file to import a schema into my tablespace. My tablespace is called DEMO. The impdp command I am running is:
impdp DEMOUSER/DEMOUSER@dev dumpfile=AR_TABLES.dmp logfi...
why I am getting this error, as I am passing all values to the statement.
PROCEDURE sp_cga_assessment_insert (
in_competency_id IN NUMBER,
in_doc_id IN N...
I am using Oracle 11g on Windows Xp Service Pack 2. After restarting my computer and then loading up the database control I get the following error under the Agent connection to Instance:
Sta...
Im attempted to create a simple Java app that makes a connection to an Oracle 10g Express Edition database on a Windows XP computer. I have already created and populated the database (myTestD...
I am using an Oracle Db with a table that will maintain notes about workitems being passed through our distribution process.... yeah yeah...
What I want to do is insert a new 'note' only if...
Receivng ERROR Column not found before end of logical record
(use TRAILING NULLCOLS)
How do u use trailing NullCols in the control file.
I have to change my computer name after I installed oracle and created a database
so I can not connect the database
to solve this problem, I tried something
I chanbged host names in tnsn...
Hi,
I have the following function in which I created in Sybase but need to convert to Oracle and having difficulty, Any help would be greatly appreciated.
CREATE FUNCTION "AFM"."BRG_DATE...
I found the split function below at this URL:
http://builder.com.com/5100-6388_14-5259821.html
create or replace function split(p_list in varchar2, p_del in varchar2 := ',') return split...
I have Oracle9.2.x Enterprise installed on my computer. I have created the database and have created a user with certain admin privileges. When I try to create a table in sqlplus, I get the fo...
ORA-04063: package body has errors
If this is the alert,does this mean that we need to recompile the package , in order to handle this alert?
Oracle gurus,
I am starting a course on Oracle and am planning to pursue the OCP exams. I have a decent background on SQL and procedures from M$ Server and Access.
Does anyone have a r...
Hi,
I am new to Oracle developer and I am trying to understand forms creation. Since I am beginner I have no clarity about form triggers and I am confusing quite often and I could not able to...
Experts,
How can I insert values into a table via
Insert statements , when I have a description field having values like :
P& G , J &J, M&N , J & Bros , G & Sons etc
(Basically havin...
Hi,
I've successfully created a clustered index on Microsoft SQL server, but I'm not sure how to do this with Oracle as I don't usually have to work with Oracle.
On MSSQL I write
crea...
I had the install up and running months before my network was moved to a different location. This is Oracle 10g Personal Edition, so of course it required a Loopback Adapter. When I moved th...
Hello experts,
I am having a bit of an issue I was tasked with patch an Oracle server and everything was going well until I received some invaiid statements from recompiling. There were 17 ...
