Questions[plsql]

I have created a package with the search_order function that receives F_Order as a parameter

create or replace PACKAGE BUSCAR_ORDER_PKG IS 
FUNCTION buscar_order (F_Order VARCHAR2)
RETURN VARCHAR2;
END BUSCAR_ORDER_PKG;

The function is executed as such but when the parameter is empty it returns the error ORA-06503: PL/SQL: Function returned without value and from there it does not happen even when it has an exception.

create or replace PACKAGE BODY BUSCAR_ORDER_PKG IS
    FUNCTION buscar_order(F_Order VARCHAR2)
    RETURN VARCHAR2 IS    
    
    l_order  varchar2(150);

        Begin
                Select Flex_Value
                    Into l_Order
                From Flex_Values
                Where Flex_Value_Id = (Select Flex_Value_Id 
                                            From Flex_Values
                                            Where Flex_Value_Name = 'PROJECT')
                    And Flex_Value = NVL(F_Order,'X')
                    And Enabled_Flag = 'Y'
                    And Trunc(Nvl(End_Date_Active,Sysdate)) >= Trunc(Sysdate);
        Exception
        WHEN OTHERS THEN   
        l_Order := null;
       
        end buscar_order;          
END  BUSCAR_ORDER_PKG;

I am storing a file in a temporary table.

 Declare 
    l_nombre_archivo = varchar2(300);    
    
   Begin

          select filename
             INTO   l_nombre_archivo
          FROM apex_application_temp_files              
          where name = :P200_FILE; ---Es el file browser

          :P200_FILENAME := l_nombre_archivo;  ---:P200_FILENAME es el label

   End;

Then I print the filename in a label and it looks like this: myfile.txt

How can I remove the .txt characters?

Expected result print only: myfile

Apparently I just ran out of space in my tablespace and I don't know how to increase its size, I tried the following command:

ALTER TABLESPACE SANDRA ADD DATAFILE '/u01/oradata/userdata03.dbf' SIZE 3000M;

and I get:

ORA-32771: cannot add file to bigfile tablespace

I don't know what else to try. If someone could tell me what to do I would appreciate it.

I have created a table called seasons

id_estacion estacion 
1 Radio la Que buena
2 Radio Corazón
3 Radio la Chévere

I display these values ​​in a select list (multiple selection) with a station display and return id_station these data are stored in the form_request table

How to do a select from the form_request table and show me the values ​​separated by a comma by station name and not by id_station ?

So far I have this code that only works with single values

SELECT CASE
WHEN ESTACION = '1' THEN (SELECT ESTACION FROM estacion WHERE id_eiexport = '1')
WHEN ESTACION = '2' THEN (SELECT ESTACION FROM estacion WHERE id_eiexport = '2')
WHEN ESTACION = '3' THEN (SELECT ESTACION FROM estacion WHEREid_eiexport = '3')
FROM FORM_REQUEST

I want my select to show(separated by comma) when the person made multiple selection

Radio Corazón, Radio la Chévere
Radio La Que buena, Radio Corazón

But it returns me by id_station this:

id | estacion
_____________
1  | 2, 3
2  | 1, 2

It can be obtained in a single select???

An example company ID, department and production carried out

Obtain the percentage of production: the production of the person between the production of his department of his department ( production person * 100 / production department

• Department production:

  select departamento, sum(produción) 
  from empresa
  group by departamento
  

• worker production

  select dni, departamento,sum(produción)
  from empresa
  group by dni,departamento