Also, Benthic Golden is the utility us developers use to interact with Oracle as that is what our company has licenses for (we cannot use other suites I believe). In the original package, the query is put into a cursor which is an out parameter for the procedure which eventually gets exported. I'm going to be sharing this workspace with a fellow employee and I don't want them to get too confused. I want to run this query only so I can see what might happen before actually making it do what I want it to do.

I don't want to run the Procedure this code is in in the Package because there are update and insert statements. However, I'm trying to keep this as structured as it is in the Package it's in. Now, I do believe I could probably change the DECLARE to var, remove the BEGIN and END, and then put the first query as a subquery in the second query and that should work. lCustID INTEGER := 205 - Production Customer5 lCustID INTEGER := 204 - Production Customer4 lCustID INTEGER := 203 - Production Customer3 lCustID INTEGER := 202 - Production Customer2 lCustID INTEGER := 201 - Production Customer1 lCustID INTEGER := 105 - Testing Customer5 lCustID INTEGER := 104 - Testing Customer4 lCustID INTEGER := 103 - Testing Customer3 lCustID INTEGER := 102 - Testing Customer2 lCustID INTEGER := 101 - Testing Customer1 lCustID INTEGER := 5 - Development Customer5 lCustID INTEGER := 4 - Development Customer4 lCustID INTEGER := 3 - Development Customer3 lCustID INTEGER := 2 - Development Customer2 LCustID INTEGER := 1 - Development Customer1 I'm not great with cursors, am not sure if that'd be the right answer, but figured I'd ask you all since you all have helped me quite a bit in the past. However, the last statement is a query and I want it to return in the results window, but it's telling me it's expecting an INTO statement. I wanted to create tabs for each different type of export and have variables for the different customers in each tab so I can easily run them on any DB instance for any customer. They're the same queries for each customer but are filtered by an ID. I have queries for some exports for different customers. below is the screen shot of Dependency Hierarchy of service module.Sorry for the very generic title, can't think of the best way to put it in short words. In eclipse when i open the Dependency Hierarchy of service module, it shown the DAO module as a folder not jar. I am trying the find to solution from web, but still the solution is not found. LifecycleExecutionException: Failed to execute goal on project empirecl-service: Could not resolve dependencies for project com.netsol:empirecl-service:jar:0.0.1-SNAPSHOT: Failed to collect dependencies at com.netsol:empirecl-dao:jar:0.0.1-SNAPSHOT The Dao module maven clean and install successfully, but when i trying to use service module, it will generate an following exception: Failed to execute goal on project empirecl-service: Could not resolve dependencies for project com.netsol:empirecl-service:jar:0.0.1-SNAPSHOT: Failed to collect dependencies at com.netsol:empirecl-dao:jar:0.0.1-SNAPSHOT: Failed to read artifact descriptor for com.netsol:empirecl-dao:jar:0.0.1-SNAPSHOT: Could not find artifact com.netsol:empirecl:pom:0.0.1-SNAPSHOT -> When I create a module using eclipse, I was selecting packaging as a jar, but when the module is created, the packaging tag was not mention in child pom.xml and I manually insert the packaging tag as a jar. the project is created successfully but when I am trying to use one module as a dependency of another module, it throws an exception. I am trying to create a maven multi-module project.

Remove oracle workspace manager