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

4 votes214 views5 answers
Get last query in codeigniter 4
SQL
0 vote190 views1 answer
MySql get primary keys of table
SQL
0 vote280 views2 answers
Reduce size of SQL server log file truncate - Source :NAYCode.com
SQL
0 vote172 views1 answer
Parent: [Error: SQLITE_READONLY: attempt to write a readonly database] {
SQL
1 vote178 views1 answer
Convert varchar to int in sqlite
SQL
4 votes172 views2 answers
Oracle unlock user
SQL
1 vote177 views2 answers
Update with inner join sql server
SQL
1 vote202 views2 answers
Drop table with constraints
SQL
17 votes239 views2 answers
How to assign date field for table in mysql
SQL
0 vote179 views3 answers
How to run sql query
SQL