How packaged procedures and functions are called from the following?

How packaged procedures and functions are called from the following?
by

1 Answer

Answer :

a. Stored procedure or anonymous block
b. an application program such a PRC *C, PRO* COBOL
c. SQL *PLUS??
a. PACKAGE NAME.PROCEDURE NAME (parameters);
variable := PACKAGE NAME.FUNCTION NAME (arguments);
EXEC SQL EXECUTE
b.BEGIN PACKAGE NAME.PROCEDURE NAME (parameters)
variable := PACKAGE NAME.FUNCTION NAME (arguments);
END;
END EXEC;
c. EXECUTE PACKAGE NAME.PROCEDURE if the procedures does not
have any out/in-out parameters. A function can not be called.
by

Related questions

Explain how procedures and functions are called in a PL/SQL block ?

Description : Explain how procedures and functions are called in a PL/SQL block ?

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

What are different modes of parameters used in functions and procedures?

Description : What are different modes of parameters used in functions and procedures?

Last Answer : IN -OUT -INOUT

What is an UTL_FILE.What are different procedures and functions associated with it?

Description : What is an UTL_FILE.What are different procedures and functions associated with it?

Last Answer : UTL_FILE is a package that adds the ability to read and write to operating system files. Procedures associated with it are FCLOSE, FCLOSE_ALL and 5 procedures to output data to a file PUT, ... , PUTF, FFLUSH.PUT, FFLUSH.PUT_LINE,FFLUSH.NEW_LINE. Functions associated with it are FOPEN, ISOPEN.

What is difference between Procedures and Functions ?

Description : What is difference between Procedures and Functions ?

Last Answer : A Function returns a value to the caller where as a Procedure does not.

What is Overloading of procedures ?

Description : What is Overloading of procedures ?

Last Answer : The Same procedure name is repeated with parameters of different datatypes and parameters in different positions, varying number of parameters is called overloading of procedures. e.g. DBMS_OUTPUT put_line

What are Database Triggers and Stored Procedures

Description : What are Database Triggers and Stored Procedures

Last Answer : Database Triggers :: Database Triggers are Procedures that are automatically executed as a result of insert in, update to, or delete from table. Database triggers have the values old and new to ... procedures is that many users can use the same procedure in compiled and ready to use format.

What are advantages fo Stored Procedures?

Description : What are advantages fo Stored Procedures?

Last Answer : Extensibility,Modularity, Reusability, Maintainability and one time compilation.

What are the unrestricted procedures used to change the popup screen position during run time ?

Description : What are the unrestricted procedures used to change the popup screen position during run time ?

Last Answer : Anchor-view Resize -View Move-View.

How will you enforce security using stored procedures?

Description : How will you enforce security using stored procedures?

Last Answer : Don't grant user access directly to tables within the application. Instead grant the ability to access the procedures that access the tables. When procedure executed it will execute the privilege of procedures owner. Users cannot access tables except via the procedure.

How will you enforce security using stored procedures?

Description : How will you enforce security using stored procedures?

Last Answer : Don't grant user access directly to tables within the application. Instead grant the ability to access the procedures that access the tables. When procedure executed it will execute the privilege of procedures owner. Users cannot access tables except via the procedure.

What are stand-alone procedures?

Description : What are stand-alone procedures?

Last Answer : Procedures that are not part of a package are known as stand-alone because they independently defined. A good example of a stand-alone procedure is one written in a SQL*Forms application. These ... limitation of stand-alone procedures is that they are compiled at run time, which slows execution.

What are stored-procedures? And what are the advantages of using them.

Description : What are stored-procedures? And what are the advantages of using them.

Last Answer : Stored procedures are database objects that perform a user defined operation. A stored procedure can have a set of compound SQL statements. A stored procedure executes the SQL commands and returns the result to the client. Stored procedures are used to reduce network traffic.

What are the return values of functions SQLCODE and SQLERRM ? What is Pragma EXECPTION_INIT ? Explain the usage ?

Description : What are the return values of functions SQLCODE and SQLERRM ? What is Pragma EXECPTION_INIT ? Explain the usage ?

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

Explain the use of table functions.

Description : Explain the use of table functions.

Last Answer : Table functions are designed to return a set of rows through PL/SQL logic but are intended to be used as a normal table or view in a SQL statement. They are also used to pipeline information in an ETL process.

What are Procedure,functions and Packages

Description : What are Procedure,functions and Packages

Last Answer : Procedures and functions consist of set of PL/SQL statements that are grouped together as a unit to solve a specific problem or perform set of related tasks. Procedures do not ... Provide a method of encapsulating and storing related procedures, functions, variables and other Package Contents

Name the tables where characteristics of Package, procedure and functions are stored ?

Description : Name the tables where characteristics of Package, procedure and functions are stored ?

Last Answer : User_objects, User_Source and User_error.

What are the built-ins used for finding object ID functions?

Description : What are the built-ins used for finding object ID functions?

Last Answer : Find_group(function) Find_column(function)

Name of the functions used to get/set canvas properties?

Description : Name of the functions used to get/set canvas properties?

Last Answer : Get_view_property, Set_view_property

My boyfriend got one of those coffee machines that uses the cups. I think they are called K cups. Are there other kinds of beverages you can make in them and can you use regular coffee or are they only for coffee in those pre-packaged cups?

Description : My boyfriend got one of those coffee machines that uses the cups. I think they are called K cups. Are there other kinds of beverages you can make in them and can you use regular coffee or are they only for coffee in those pre-packaged cups?

Last Answer : Pod machines use small disks of coffee prepackaged, as K-cups, in their own filter-paper. To brew, pod into the machinyou slip ae and press a button. The main advantage of the pod machine ... of coffee available, because the the pod is standard, many different companies can offer in pod form.

What is not True for DNA in prokaryotes a) present in the form of a compact structure called nucleoid b) the coils are maintained by non-histone basic proteins c) found in cytoplasm in a supercoiled condition d) packaged as nucleosomes along with histones

Description : What is not True for DNA in prokaryotes a) present in the form of a compact structure called nucleoid b) the coils are maintained by non-histone basic proteins c) found in cytoplasm in a supercoiled condition d) packaged as nucleosomes along with histones

Last Answer : b) the coils are maintained by non-histone basic proteins

Which statement is correct regarding the relationship between internal auditing and the external auditor? a. Some judgments relating to the audit of the financial statements are those of the internal auditor. b. The external audit function's objectives vary according to management's requirements. c. Certain aspects of internal auditing may be useful in determining the nature, timing and extent of external audit procedures. d. The external auditor is responsible for the audit opinion expressed, however that responsibility may be reduced by any use made of internal auditing

Description : Which statement is correct regarding the relationship between internal auditing and the external auditor? a. Some judgments relating to the audit of the financial statements are those of the ... opinion expressed, however that responsibility may be reduced by any use made of internal auditing

Last Answer : Certain aspects of internal auditing may be useful in determining the nature, timing and extent of external audit procedures.

The term module in the design phase refers to ? Functions Procedures Sub programs All of the above

Description : The term module in the design phase refers to ? Functions Procedures Sub programs All of the above

Last Answer : All of the above

Defects discovered by static analysis tools include: i. Variables that are never used. ii. Security vulnerabilities. iii. Programming Standard Violations iv. Uncalled functions and procedures a) i , ii,iii,iv is correct b) iii ,is correct I,ii,iv are incorrect. c) i ,ii, iii and iv are incorrect d) iv, ii is correct

Description : Defects discovered by static analysis tools include: i. Variables that are never used. ii. Security vulnerabilities. iii. Programming Standard Violations iv. Uncalled functions and procedures a) i , ii,iii,iv is correct b ... ,iv are incorrect. c) i ,ii, iii and iv are incorrect d) iv, ii is correct

Last Answer : a) i , ii,iii,iv is correct

Do you freak out if you find an insect or insect parts in your packaged foods?

Description : Do you freak out if you find an insect or insect parts in your packaged foods?

Last Answer : I can’t say that’s ever happened to me.

Why are egg noodles (in the US) still packaged in those crisp bags that tear wide open and then disintegrate when you go to use them?

Description : Why are egg noodles (in the US) still packaged in those crisp bags that tear wide open and then disintegrate when you go to use them?

Last Answer : They do this to maximize profits when the packaging costs more than the contents.

ask-public challenge: How many foods can you name, not including fresh fruits and vegetables, that you buy from a grocery store that don't come pre-packaged in some way, in some sort of plastic?

Description : ask-public challenge: How many foods can you name, not including fresh fruits and vegetables, that you buy from a grocery store that don't come pre-packaged in some way, in some sort of plastic?

Last Answer : answer:My grocery store has a meat section that's kind of like a butcher shop, they cut up the meat for you. Beef, sausages, whatever. Obviously they wrap it when they give you it, but otherwise it ... While there is packaged fish, the ones behind the counter aren't, and there's also a lobster tank.

Do most packaged and prepared foods have too much sauce for you?

Description : Do most packaged and prepared foods have too much sauce for you?

Last Answer : answer:I don't buy food that comes with sauce. My husband sometimes has a packaged/prepared pasta dish and he said he'd usually prefer a bit more sauce. When we eat out, it's rare I've had a meal that ... in sauce. I think asking for a second plate or for the sauce on the side makes a lot of sense.

Did you ever buy a packaged product (perhaps not sealed) only to find out that it was empty when you got home?

Description : Did you ever buy a packaged product (perhaps not sealed) only to find out that it was empty when you got home?

Last Answer : answer:I have this problem re-selling from a mall. I've learned that you cannot re-sell a DVD with a risque depiction of the female form on the cover. Some boy will steal the disk and leave the box. I ... a really close watch, knowing that there's nothing to be done, and it will just make me mad. :)

When you buy packaged lettuce at the "organic" grocery store, do trust the label when it says "Pre-Washed"?

Description : When you buy packaged lettuce at the "organic" grocery store, do trust the label when it says "Pre-Washed"?

Last Answer : No, I wash it again too. Someone might not be as diligent as cleaning the veggies as I would be.

How do they clean the bug poop off of herbs that are being dried and packaged for commercial sale?

Description : How do they clean the bug poop off of herbs that are being dried and packaged for commercial sale?

Last Answer : Is there a lot of bug poop on those herbs?

Do you have any advice for someone who wants to market a packaged food product?

Description : Do you have any advice for someone who wants to market a packaged food product?

Last Answer : It depends where you live, of course, but before getting too into the marketing and distribution end, it pays to learn about the local regulations and what it would take to produce the food product legally. ... kitchen. For instance, if you live in Michigan, here is what you will have to deal with.

What is your favorite dry packaged breakfast cereal?

Description : What is your favorite dry packaged breakfast cereal?

Last Answer : I love variety. I couldn’t do the same cereal every morning. My most frequent is Shredded Wheat.

Why doesn't protein get a daily percentage on a packaged food's nutritional information label?

Description : Why doesn't protein get a daily percentage on a packaged food's nutritional information label?

Last Answer : That is strange. Those percentages are awful anyway. I don’t think the percentages mean anything to anyone.

What's a nice treat (non-packaged) for a deserving cat?

Description : What's a nice treat (non-packaged) for a deserving cat?

Last Answer : Have you tried Greenies? Low sodium tuna Bits of unseasoned chicken My cats love to lick butter off of my fingers

Why are poptarts packaged in as two when the serving size is one?

Description : Why are poptarts packaged in as two when the serving size is one?

Last Answer : Buy a plastic, airtight food container. You can throw any Lonely Tarts™ in there without having to seal the foil on them first. They’ll last forever.

Can you freeze (fresh/ but still packaged) salsa and then eat it?

Description : Can you freeze (fresh/ but still packaged) salsa and then eat it?

Last Answer : I have noticed that when you freeze watery fruits and vegetables, like apples, tomatoes, peaches, etc. the freeze/thaw action breaks down the cellulose structure of the food and it becomes very mushy ... make the best banana bread) and when they thawed, they were the consistency of apple sauce.

Good vegetarian matzo-ball soup recipe without using the packaged soup-mix?

Description : Good vegetarian matzo-ball soup recipe without using the packaged soup-mix?

Last Answer : Tough w/o a real chicken for broth (unless you made veggie broth) and impossible to bind the matzo-meal w/o egg, if you want the authentic flavor. I think that substituting oil for schmaltz is ... still doesnt taste like Grandma's. Her matzoh balls could knock down bowling pins, but they were good.

A soccer ball is packaged in a cubic box with side lengths of 22 cm. Assuming that the ball touches all faces of the box, calculate what percentage of the volume of the box is wasted space Write it step by step pls?

Description : A soccer ball is packaged in a cubic box with side lengths of 22 cm. Assuming that the ball touches all faces of the box, calculate what percentage of the volume of the box is wasted space Write it step by step pls?

Last Answer : one centimetre

A soccer ball is packaged in a cubic box with side lengths of 22 cm. Assuming that the ball touches all faces of the box, calculate what percentage of the volume of the box is wasted space?

Description : A soccer ball is packaged in a cubic box with side lengths of 22 cm. Assuming that the ball touches all faces of the box, calculate what percentage of the volume of the box is wasted space?

Last Answer : one centimetre

What a factory processes 1,560 ounces of olive oil per hour. The oil is packaged into 24-ounce bottles. How many bottles does the factory fill in one hour?

Description : What a factory processes 1,560 ounces of olive oil per hour. The oil is packaged into 24-ounce bottles. How many bottles does the factory fill in one hour?

Last Answer : Nevermind

Will packaged cigarettes come out cheaper?

Description : More and more people are buying tubes and filling them with tobacco, it's probably about the price, isn't it?

Last Answer : Yes, I smoke about 20 cigarettes a day and this way I can save. But taste is no miracle.

Is there a MiniDisc Recorder that comes packaged with everything it needs, and would make a good gift for a graduate?

Description : Is there a MiniDisc Recorder that comes packaged with everything it needs, and would make a good gift for a graduate?

Last Answer : Yes. But no, it wouldn't make a good gift. Go with a mp3 player.

About Packaged Food Diets?

Description : About Packaged Food Diets?

Last Answer : There are many diets on the market that offer prepackaged food choices. Dieters rely on these meals as the majority of the food they consume each day. Jenny Craig, Nutrisystem and Medifast are a ... for weight loss. Because of this, many people have great success with packaged food diet plans.

Genes are packaged into a bacterial chromosome by (a) acidic protein (b) actin (c) histones (d) basic protein.

Description : Genes are packaged into a bacterial chromosome by (a) acidic protein (b) actin (c) histones (d) basic protein.

Last Answer : basic protein

What among the following is the feature of experienced goods ? 1. These are intangible 2. These cannot be packaged 3. These cannot be touched 4. These can be evaluated only after use 5. all the above

Description : What among the following is the feature of experienced goods ? 1. These are intangible 2. These cannot be packaged 3. These cannot be touched 4. These can be evaluated only after use 5. all the above

Last Answer : all the above

Amazon Machine Images are virtual appliances that have been packaged to run on the grid of ____ nodes. a) Ben b) Xen c) Ken d) Zen

Description : Amazon Machine Images are virtual appliances that have been packaged to run on the grid of ____ nodes. a) Ben b) Xen c) Ken d) Zen

Last Answer : Xen

Amazon Machine Images are virtual appliances that have been packaged to run on the grid of ____ nodes. a) Ben b) Xen c) Ken d) Zen

Description : Amazon Machine Images are virtual appliances that have been packaged to run on the grid of ____ nodes. a) Ben b) Xen c) Ken d) Zen

Last Answer : Xen

Amazon Machine Images are virtual appliances that have been packaged to run on the grid of ____ nodes. a) Ben b) Xen c) Ken d) Zen

Description : Amazon Machine Images are virtual appliances that have been packaged to run on the grid of ____ nodes. a) Ben b) Xen c) Ken d) Zen

Last Answer : Xen

Computer software includes___ 1 Application programs 2 Operating system programs 3 Packaged programs 4 All of these

Description : Computer software includes___ 1 Application programs 2 Operating system programs 3 Packaged programs 4 All of these

Last Answer : 4 All of these

What is packaged software?

Description : What is packaged software?

Last Answer : Off-the-shelf programs designed for specific classes of applications.