Code Monkey home page Code Monkey logo

Comments (8)

mickeypearce avatar mickeypearce commented on June 2, 2024

Can you please post whole text of the error output, including your project path if that is posible.

I suspect there is a space in your project file path or someting similar, that causes the error in getDBObjectFromPath function.

Thanks for your help.

from oradew-vscode.

gitguddy avatar gitguddy commented on June 2, 2024

The Error:

> Executing task: node /home/oracle/.vscode/extensions/mp.oradew-vscode-0.3.11/node_modules/gulp/bin/gulp.js --cwd /home/oracle/Dokumente/Oradew_Test --gulpfile /home/oracle/.vscode/extensions/mp.oradew-vscode-0.3.11/out/gulpfile.js --color true --silent true create --env DEV <

Created file ./src/HR/PACKAGES/HR_TEST_PKG.sql
Created file ./src/HR/PROCEDURES/SECURE_DML.sql
Created file ./src/HR/PROCEDURES/ADD_JOB_HISTORY.sql
Created file ./src/HR/PACKAGE_BODIES/HR_TEST_PKG.sql
Created file ./src/HR/VIEWS/EMP_DETAILS_VIEW.sql
Created file ./src/HR/TRIGGERS/SECURE_EMPLOYEES.sql
Created file ./src/HR/TRIGGERS/UPDATE_JOB_HISTORY.sql
Created file ./src/HR/TRIGGERS/EMPLOYEES_EMPLOYEE_ID_TRG.sql
Created file ./src/HR/TABLES/REGIONS.sql
Created file ./src/HR/TABLES/COUNTRIES.sql
Created file ./src/HR/TABLES/LOCATIONS.sql
Created file ./src/HR/TABLES/DEPARTMENTS.sql
Created file ./src/HR/TABLES/JOBS.sql
Created file ./src/HR/TABLES/EMPLOYEES.sql
Created file ./src/HR/TABLES/JOB_HISTORY.sql
Cannot read property 'toLowerCase' of undefined
The terminal process terminated with exit code: 1

Terminal will be reused by tasks, press any key to close it.

The Project path of an generated file:
/home/oracle/Dokumente/Oradew_Test/src/HR/VIEWS/EMP_DETAILS_VIEW.sql

from oradew-vscode.

mickeypearce avatar mickeypearce commented on June 2, 2024

Nothing unusual ...

One more thing, can you please open an empty file that was created (i.e.: ./src/HR/PACKAGES/HR_TEST_PKG.sql) and execute "Import Current File" (there is a link in the right-click menu or from Command Pallete)

from oradew-vscode.

gitguddy avatar gitguddy commented on June 2, 2024

I tried and got this error:

> Executing task: node /home/oracle/.vscode/extensions/mp.oradew-vscode-0.3.11/node_modules/gulp/bin/gulp.js --cwd /home/oracle/Dokumente/Oradew_Test --gulpfile /home/oracle/.vscode/extensions/mp.oradew-vscode-0.3.11/out/gulpfile.js --color true --silent true import --env DEV --file /home/oracle/Dokumente/Oradew_Test/src/HR/TABLES/DEPARTMENTS.sql <

ORA-31600: invalid input value FILE for parameter OBJECT_TYPE in function GET_DDL
ORA-06512: at "SYS.DBMS_METADATA", line 6478
ORA-06512: at "SYS.DBMS_METADATA", line 6264
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA_INT", line 4152
ORA-06512: at "SYS.DBMS_METADATA_INT", line 4629
ORA-06512: at "SYS.DBMS_METADATA_INT", line 9617
ORA-06512: at "SYS.DBMS_METADATA", line 6207
ORA-06512: at "SYS.DBMS_METADATA", line 6320
ORA-06512: at "SYS.DBMS_METADATA", line 9202
ORA-06512: at line 1

Terminal will be reused by tasks, press any key to close it.

from oradew-vscode.

mickeypearce avatar mickeypearce commented on June 2, 2024

I have difficulties in reproducing this, because I am on different platform (Win). But it seems as it fails when parsing the file path (to extract "dir", "owner", "objectName" and "objectType", etc.)

oradew-vscode/src/common/utility.js

Lines 46 to 57 in 01f5582

const base = resolve("./");
const relPath = relative(base, absPath);
const pathSplit = relPath.split(sep);
let owner, objectName, dir, objectType, objectType1;
// Object name is always from file name
objectName = parse(absPath).name;
let isScript, isSource;
// Glob matching is too costy...
isScript = pathSplit[0].toLowerCase() === "scripts";
isSource = pathSplit[0].toLowerCase() === "src";

Can you tell me the version of Node you are using. Thanks again (really helpful 👍 )

from oradew-vscode.

gitguddy avatar gitguddy commented on June 2, 2024

Node version is:
v10.16.3

from oradew-vscode.

mickeypearce avatar mickeypearce commented on June 2, 2024

and OS? :)

from oradew-vscode.

mickeypearce avatar mickeypearce commented on June 2, 2024

@gitguddy , I rewrote the critical function in the latest version (0.3.12). Can you please confirm if it works now? Thanks again for you help!

from oradew-vscode.

Related Issues (20)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.