Can You Call Procedure In Oracle From Sqr? How?

1.	Can You Call Procedure In Oracle From Sqr? How?
Answer» To call a database procedure using Begin-select PARAGRAPH, the syntax is as FOLLOWS: Begin-select [(REPORT ARGUMENTS)] from Dual End-select To call from Begin-sql, the syntax will be Begin-SQL ;; End-SQL To call a database procedure using Begin-select paragraph, the syntax is as follows: Begin-select [(report arguments)] from Dual End-select To call from Begin-sql, the syntax will be Begin-SQL ;; End-SQL

Answer»

To call a database procedure using Begin-select PARAGRAPH, the syntax is as FOLLOWS:

Begin-select
[(REPORT ARGUMENTS)]
from Dual
End-select
To call from Begin-sql, the syntax will be

Begin-SQL
;;
End-SQL

To call a database procedure using Begin-select paragraph, the syntax is as follows:

Begin-select
[(report arguments)]
from Dual
End-select
To call from Begin-sql, the syntax will be

Begin-SQL
;;
End-SQL

Discussion