I can´t connect with a oracle db

rajnvr wrote:
Where can you find these words and what do you mean with master-detail?

What you can do know is linkable content, creating master table and link to article with detail table. It is not possible yet to link with foreign key, but we are not far away to do that, only if there will be an interest for that option.

We are sorry if documentation is inadequate, we will try to write it more precisely.

Best regards,
Viljem

Thanks for your prompt reply.

The word master detail is mentioned in the Jommla extension directory. please refer the link below

extensions.joomla.org/extensions/core-en...s/data-reports/10340

Also, regarding the master detail. As you mentioned that you are not too far away from linking the child data through referential integrity. Until you have one, how to link the child data with the parent one.

These are the basic documentation needed and they are missing. thats the only concern.

please provide a simple brief documentation which explains linking child data with master data.

Thanks for your time.

Regards,
Raja

Thanks.

I did exactly as you mentioned and great it connected to oracle DB but I'm getting following error if query it from the database.

Warning: oci_execute() [function.oci-execute]: ORA-00911: invalid character in C:\wamp\www\dw\libraries\joomla\database\database\oracle.php on line 279


please advise

rajnvr wrote:

"Master-detail view" is in comment of one of our customers. He was probably trying to say, that it is possible to create view, that has join master with detail table, and this view is shown with TableJX.

Although it is possible to create parent table or view (joined with jos-content -> here are articles stored). This parent table has ArticleID column (not necessary to show this column), and other column/columns with links to article (e.g. ArticleID=55) with child table/view (inserted child table/view).

What is missing here is automation that can be brought with dynamic content on article dependent on foreign key in parent table (1-1, 1-m, m-m mappings supported). As I said if there will be interest we will also do this, but how many people will this really use?

About Oracle:
I don't know which Instant Oracle Client did you download, there are planty of them (many Oracle DB versions). I suggest you to use TableJX version 4 (could be downloaded in customer area)

Best regards,
Viljem

Ok, the oracleTest.php is working correctly but the extension not working... why???

Now no show any error... but not show the list tables... and I try push Preview and this is the error:

Warning: oci_execute() [function.oci-execute]: ORA-00900: sentencia SQL no valida in /var/www/sala/libraries/joomla/database/database/oracle.php on line 279

line 277 $this->_errorNum = 0;
line 278 $this->_errorMsg = '';
line 279 $this->_cursor = oci_execute( $this->_prepared );
line 277