Method and apparatus of parameter passing of structured data for stored procedures in a content management system

A method of communicating data between a client and a stored procedure in a server comprising:

• calling, by the client, a utility interface program in the server to encode the data;
• encoding, by the utility interface program, the data to a structured data format including a plurality of elements thus providing encoded data;
• and
• transmitting, by the utility interface program, the encoded data in the structured data format to the stored procedure.

A content management system comprising:

• a client;
• a server, responsive to the client, the server including:
• a database repository;
• a stored procedure;
• and
• a utility interface program, which when called by the client, encodes data from the client to a structured data format including a plurality of elements, thus providing encoded data to the stored procedure.

A computer program product for facilitating communication of data in a content management system, the computer program product including a plurality of computer executable instructions stored on a computer readable medium, wherein the instructions, when executed by the content management system, cause the system to perform the steps of:

• calling, by a stored procedure in a server, a utility interface program in the server to encode the data;
• encoding, by the utility interface program, the data in a structured data format including a plurality of elements thus providing encoded data;
• and
• transmitting, by the server, the encoded data in the structured data format to the client.