CODEWITHSUNDEEP
oracle-databasestored-proceduresplsql
TonyP
TonyP

Reputation: 5873

How to retrieve Number(Precision,Scale) of an Oracle stored procedure parameter

Is there any schema/table that describe precision and scale of a Number parameter of a Oracle procedure ?

Upvotes: 0

Views: 690

Answers (1)

John Doyle
John Doyle

Reputation: 7793

The view USER_ARGUMENTS contains the arguments for your stored procedures (plus ALL_ARGUMENTS for those you have access to and DBA_ARGUMENTS for every stored procedure/function in the database). The columns DATA_TYPE, DATA_LENGTH, DATA_PRECISION, etc. are what you are looking for.

See here.

Upvotes: 3

Related Questions