Why do I receive the error "??? Undefined function or variable 'getTheMetaData'." when I select certain tables using the Visual Query Builder in MATLAB?

1 visualización (últimos 30 días)
Why do I receive the error "??? Undefined function or variable 'getTheMetaData'." when I select certain tables using the Visual Query Builder in MATLAB?
I am having some problems using the Matlab Database toolbox to access an Oracle database. In the Visual Query builder, there are some tables from the database for which I cannot see the fields. When I select those table in the table list I get the following error messages:
??? Undefined function or variable 'getTheMetaData'.
Error in ==> D:\MATLAB6p5\toolbox\database\database\@cursor\columnnames.m
On line 46 ==> md = getTheMetaData(cursor.Fetch);
Error in ==> D:\MATLAB6p5\toolbox\database\vqb\querycallbacks.m
On line 749 ==> tmp = columnnames(ex);
??? Error while evaluating uicontrol Callback.
When I try to get the fields from the table using the following code:
db_connection = database('enrg','','') ;
query1 = 'select * from GEODE0310 where scn =1 and poste =1;' ;
cursor1 = exec(db_connection,query1) ;
message1 = cursor1.Message ;
message1
message1 =
[Oracle][ODBC][Ora]ORA-00942: table or view does not exist

Respuesta aceptada

MathWorks Support Team
MathWorks Support Team el 27 de Jun. de 2009
To resolve this problem, create a synonym for the table. Also, specify the table in lower case or enclose it in double quotes:
query2 = 'select * from "AREAS" ;';

Más respuestas (0)

Categorías

Más información sobre Structures en Help Center y File Exchange.

Productos

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by