Can you invoke a Procedure inside Package P1 from the other package P2 in the same schema? Explain

Tanvi Singh

• Mar 24th, 2017

Yes we can invoke a procedure from another package if the procedure is of type public.

Answer Question  Select Best Answer

Write a PLSQL function that accepts some text and validates that the text has only Alphanumeic characters and returns true else returns false

Priya

• Oct 25th, 2018

LENGTH(TRIM(TRANSLATE(string1, abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ+-.0123456789, )))

This function will return a null value if string1 is alphanumeric. It will return a value "greater than 0" if string1 contains any non-alphanumeric characters.

Answer Question  Select Best Answer

 Some  scalar  data  types  such  as NUMBER, VARCHAR2, DATE, CHAR, LONG, BOOLEAN.Some composite data types such as RECORD & TABLE.

g_sidhu

 Profile Answers by g_sidhu Questions by g_sidhu

• Feb 16th, 2008

ScalarCHARVARCHAR2 LONGLONG RAWNUMBER [(precision, scale)]BINARY_INTEGERPLS_INTEGERBOOLEAN Composite TypesRECORDTABLEVARRAYLOB TypesBFILEBLOBCLOBNCLOBReference TypesREF CURSORREF object_type

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Oct 26th, 2006

Following are the datatype supported in oracle PLSQLScalar TypesBINARY_INTEGERDECDECIMALDOUBLE PRECISIONFLOATINTINTEGERNATURALNATURALNNUMBERNUMERICPLS_INTEGERPOSITIVEPOSITIVENREALSIGNTYPESMALLINTCHARC...

Answer Question  Select Best Answer

 Mutation of table occurs.

rudra pratap

• Jul 5th, 2007

In order to avoid mutation table error we need to have a row level as well as a statment level trigger.

Sunil Yadav

• Oct 26th, 2005

To avoid the mutation table error ,the procedure should be declared as an AUTONOMOUS TRANSACTION.By this the procedure will be treated as an separate identity.

Answer Question  Select Best Answer

          I.  done using Database triggers.          ii. done using Integarity Constraints. I & ii. Exception :

Srinatha Reddy

 Profile Answers by Srinatha Reddy Questions by Srinatha Reddy

• May 21st, 2008

create table a ( b number, c number check (c >100) );create or replace trigger t1 before insert on a begindbms_output.put_line('this is before insert trigger'); end;create or replace trigge...

prashant

• Jul 6th, 2006

 ii. done using Integarity Constraints

Answer Question  Select Best Answer

 SQLCODE returns the latest code of the error that has occurred.SQLERRM returns the relevant error message of the SQLCODE.

g_sidhu

 Profile Answers by g_sidhu Questions by g_sidhu

• Jan 31st, 2008

• SQLCODE: Returns the numeric value for the error code• SQLERRM: Returns the message associated with the error numberSQLCODE Value          &nbs...

acpsrinivas

 Profile Answers by acpsrinivas Questions by acpsrinivas

• Feb 25th, 2006

Pl / Sql Provides Error Information via two Built-in functions, SQLCODE & SQLERRM.SQLCODE Returns the Current Error Code.            &nb...

Answer Question  Select Best Answer

 Function is called as part of an expression.   sal := calculate_sal ('a822');   procedure is called as a PL/SQL statement   calculate_bonus ('A822');

idonknowyou

 Profile Answers by idonknowyou Questions by idonknowyou

• May 22nd, 2007

Procedure can be called in the following waysa) CALL <procedure name> direcb) EXCECUTE <procedure name> from calling environmentc) <Procedure name> from other procedures or functions...

M.KUMARAN

• Nov 13th, 2005

Function is called as part of an expression.   sal := calculate_sal ('a822');   procedure is called as a PL/SQL statement   calculate_bonus ('A822');KKK

Answer Question  Select Best Answer

 The two parts of package are PACKAGE SPECIFICATION & PACKAGE BODY. Package Specification contains declarations that are global to the packages and local to the schema.Package  Body  contains  actual  procedures  and  local  declaration of the procedures and cursor declarations.

g_sidhu

 Profile Answers by g_sidhu Questions by g_sidhu

• Jan 31st, 2008

A package usually has a specification and a body, stored separately in the database.The specification is the interface to your applications. It declares the types, variables, constants, exceptions, cu...

Mahesh Argade

• Jun 28th, 2006

In addition to this Both Package Spec and Package Body are stored separately in the Data basePackage specifications act as an interface for the Package

Answer Question  Select Best Answer

 User_objects, User_Source and User_error. 

idonknowyou

 Profile Answers by idonknowyou Questions by idonknowyou

• May 22nd, 2007

The Data dictionary tables/ Views where the characteristics of subprograms and Packages are stored are mentioned belowa) USER_OBJECTS, ALL_OBJECTS, DBA_OBJECTSb) USER_SOURCE, ALL_SOURCE, DBA_SOURCEc) USER_DEPENCENCIESd) USER_ERRORS, ALL_ERRORS, DBA_ERRORS

vinod kumar

• Nov 16th, 2005

User_source , user_object , user_errors

Answer Question  Select Best Answer

samareshp

 Profile Answers by samareshp Questions by samareshp

• Apr 15th, 2009

Sure, you can write plsql block inside exception.

Rupjit Roy

• Feb 23rd, 2006

Yes you can write PL/SQL block inside exception section. Suppose you want to insert the exception detail into your error log table, that time you can write insert into statement in exception part. To ...

Answer Question  Select Best Answer

Showstopper

 Profile Answers by Showstopper Questions by Showstopper

• Jun 21st, 2010

Begin for loopcounter in 1..10 loop dbms_output.put_line(loopcounter); end loop; end; / This piece of code will display the loopcounter in a PL/SQL loop on the screen

mekshi_2kk

 Profile Answers by mekshi_2kk Questions by mekshi_2kk

• Mar 6th, 2006

Using dbms_output.put_line(loop counter variable);

Answer Question  Select Best Answer

BASAVARAJ KOLUR

• Mar 9th, 2007

plsql supports mainly 3 types of collections    1> index by binary_integer    2> nested table    3>varrays index by binary_integer and nested...

Gupta

• Aug 7th, 2006

Types are Index -by- table, Nested Tables and Varray!

Answer Question  Select Best Answer

RoulRaj

• May 9th, 2007

Dear Rajeswaran,Please give one example(application) where one can use force view.Thanks & regards

Rajeshwaran

• Jun 3rd, 2006

usually the views are created from the basetable if only the basetable exists.The purpose of FORCE keyword is to create a view if the underlying base table doesnot exists.ex : create or replace FORCE ...

Answer Question  Select Best Answer

kamala kanta Parhi

• Oct 14th, 2006

select text from user_sourcewhere name='procedure_name';

D. Madhu

• Jun 29th, 2006

select * from user_objects where type='procedure' and name='function or procedure name'

Answer Question  Select Best Answer

sunflower

• Feb 22nd, 2007

DBMS_TRACE package can be used to keep track of the calls between the subprograms and trace of execution by sub-program, procedures, functions or an exception. It gives a large amount of trace da...

Jian Zhang

• Oct 10th, 2006

When you want to see the execute plan of a SQL statement, you need to use TRACE function of Oracle.

Answer Question  Select Best Answer

manish dudhe

• Oct 15th, 2007

Hi,User Ref cursor as out parameter in procand execute as belowsql>var s refcursorsql>exec demo_proc('manish',:s);sql>print s

Rama Krishna,TCS

• Aug 9th, 2006

Hi Mukund!!       You have to return the selected cursor as OUT parameter and again you have to fetch the data from that OUT cursor..Thanks&RegdsRamki

Answer Question  Select Best Answer

How to schedule an email in oracle reports?

KARI

• Oct 29th, 2011

UTL_MAIL: type procedure in UTL_MAIL 1)SEND (send the message without attachment) "plsql Begin UTL_MAIL.SEND(sender =>'karimuth@amazon.com',recipients=>'karimuthu.bala@gmail.com'...

zahar

 Profile Answers by zahar Questions by zahar

• Jun 7th, 2011

Using utl_mail

Answer Question  Select Best Answer

How to know the current database name in PL/SQL?

Saravanan Govindan

• Jul 20th, 2011

Select name from v$database;

Code
 

Saravanan Govindan

• Jul 20th, 2011

Select name from v$database;

Answer Question  Select Best Answer

 WHERE  CURRENT OF clause in an UPDATE,DELETE statement refers to the latest row fetched from a cursor. Database Triggers

g_sidhu

 Profile Answers by g_sidhu Questions by g_sidhu

• Jan 31st, 2008

When referencing the current row from an explicit cursor, use the WHERE CURRENT OF clause. This allows you to apply updates and deletes to the row currently being addressed, without the need to explic...

Shefali

• Aug 16th, 2006

"WHERE CURRENT OF" clause is used for updating or deleting rows selected by the cursor with FOR UPDATE cluase.It explicitily locks the row for updating or deleting.

Answer Question  Select Best Answer

 The table columns are referred as OLD.column_name and NEW.column_name.For triggers related to INSERT only NEW.column_name values only available.For  triggers related to UPDATE only OLD.column_name NEW.column_name values only available.For triggers related to DELETE only OLD.column_name values only available.

krishnaindia2007

 Profile Answers by krishnaindia2007 Questions by krishnaindia2007

• May 6th, 2008

OLD and NEW are two virtual tables available during database trigger execution.UPDATE statement has access to  both old and new values.INSERT  statement has access only to new...

bambino_chakma

 Profile Answers by bambino_chakma Questions by bambino_chakma

• Jul 15th, 2007

The two virtual table available are old and new.

Answer Question  Select Best Answer