Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to specify precision and scale for a datatype in create procedure statement

user4928701Nov 8 2013 — edited Nov 8 2013

Specifying precision and scale in the datatype when creating a procedure does not work:

create or replace function SqlTxFunctionTesting(inparam in number(9,2)

  • Error(1,48): PLS-00103: Encountered the symbol "(" when expecting one of the following: := . ) , @ % default character The symbol ":=" was substituted for "(" to continue.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 6 2013
Added on Nov 8 2013
4 comments
973 views