Function plsql

CREATE OR REPLACE FUNCTION my_schema.my_function(param1 IN number) RETURN output1 IS
    cnumber NUMBER;
BEGIN
    cnumber := 2;
    RETURN (cnumber * param1);
EXCEPTION
    WHEN OTHERS THEN
        raise_application_error(-20001, 'An error was encountered - '
            || sqlcode || ' -ERROR- ' || sqlerrm);
END;

Similar codes

0 vote223 views1 answer
Sql query inline if
SQL
0 vote280 views1 answer
Mysql show schema
SQL
6 votes178 views4 answers
Sqlite drop table
SQL
19 votes192 views5 answers
Mysql between date range
SQL
8 votes201 views4 answers
How to calculate the age from date of birth in python
SQL
3 votes197 views1 answer
How to uninstall microsoft sql server
SQL
0 vote198 views1 answer
System.Data.SqlClient.SqlException: 'Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.' SqlDataAdapter
SQL
0 vote201 views3 answers
Insert query in ci
SQL
1 vote203 views1 answer
Partition by sql server
SQL
4 votes200 views2 answers
Installing sql on ubuntu
SQL